I'm trying to run a large query using some inner joins and order by statements and I get the following error in Toad for Data Analysts.
“ORA-01652: unable to extend temp segment by 128 in tablespace TEMP”
However I'm not assigned to the default TEMP tablespace, but another temp tablespace with much more room. I can run the query in SQL Plus without error.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center