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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.