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: 25033
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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: Sat Dec 03 04:18:02 CST 2016

Total time taken to generate the page: 0.13003 seconds