Return
-
Title
Error, "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" when running a query -
Description
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.
-
Resolution
WORKAROUND:
None.
STATUS:
Waiting for a fix in a future release of Toad for Data Analysts.
-
Defect ID
ST93006