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.
Waiting for a fix in a future release of Toad for Data Analysts.