Re: Ora 1652: Unable to extend temp segment by 128 in temp ts

Thank you all for your responses. Unfortunately we had to drop this logic and do a select from another table(equivalent) due to time constraints. But I still have my query, does the outputs really make the temp buffer overflow even if we don't have any sorts ? And could there be any other reasons to cause Ora-01652 other than cartesian product in this case?

Thanking all,
gtcol Received on Tue Jan 08 2008 - 03:23:58 CST