Re: Ora 1652: Unable to extend temp segment by 128 in temp ts
From: dbagtcol <cx4gtcol_at_gmail.com>
Date: Tue, 8 Jan 2008 01:23:58 -0800 (PST)
Message-ID: <c951be2b-5de1-454d-a6e2-1bdd8dafcda1@c23g2000hsa.googlegroups.com>
Date: Tue, 8 Jan 2008 01:23:58 -0800 (PST)
Message-ID: <c951be2b-5de1-454d-a6e2-1bdd8dafcda1@c23g2000hsa.googlegroups.com>
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