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

On Jan 8, 1:23 am, dbagtcol <cx4gt..._at_gmail.com> wrote:
> 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

See this: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:374218170986

Also, show us how you defined the temp ts. Maybe you didn't do what you thought, easy mistake to make (search for temporary tablespace on metalink for lots of info).

Since you didn't post platform info, it could be something silly like using a DMT with 2k blocks...
Also, sort and aggregate init.ora parameters can make a difference, as well as autoextend (and some other obscure things can make temp usage more flagrant, I don't have time to remember right now, and there is misinformation floating about).

jg

--
@home.com is bogus.
"Tracers work both ways." - U.S. Army Ordnance