Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01652 when running procedure (Oracle 9i, winXP, Toad)
ORA-01652 when running procedure [message #328358] Thu, 19 June 2008 20:00 Go to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I run my procedure ZDSTAGE.ZLG_AUTO_REVENUE_RECON_V8 on TOAD and I get this error. what seem to be the problem?

ORA-01652: unable to extend temp segment by 16 in tablespace TEMP_DIS
ORA-06512: at "ZDSTAGE.ZLG_AUTO_REVENUE_RECON_V8", line 49
ORA-06512: at line 9
Re: ORA-01652 when running procedure [message #328359 is a reply to message #328358] Thu, 19 June 2008 20:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I get this error. what seem to be the problem?

ORA-01652: unable to extend temp segment by 16 in tablespace TEMP_DIS
Re: ORA-01652 when running procedure [message #328364 is a reply to message #328359] Thu, 19 June 2008 21:11 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

When I add filter on some where clause, that is to get less data, the proc run w/o error. do I have to contact the dba for this?
Re: ORA-01652 when running procedure [message #328373 is a reply to message #328364] Thu, 19 June 2008 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes there is not space enough in your temporary tablespace to execute the full query but are you sure you don't want to always filter?

Regards
Michel
Re: ORA-01652 when running procedure [message #328426 is a reply to message #328373] Fri, 20 June 2008 02:50 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Yes, don't want that filter. I just edit my procedure, optimize sub queries and it's now working.

thanks people!
Previous Topic: Leave Calculation (merged)
Next Topic: Dynamic SQL in REF Cursor
Goto Forum:
  


Current Time: Sun Feb 16 06:17:09 CST 2025