Home » RDBMS Server » Server Administration » Unable to extend temporary tablespace (11.2.0.4)
Unable to extend temporary tablespace [message #636755] Fri, 01 May 2015 11:32 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,

I am experience following error while deploying a code:-

ORA-20001: Unhandled Exception in PKG_TRANSFORM_WF.PR_WF_TRANS_ABL3. Err


ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

I have added space to temp table space but still could not avoid this error.

Could you recommend what else could I do to avoid this error?

Thanks,

Varun
Re: Unable to extend temporary tablespace [message #636756 is a reply to message #636755] Fri, 01 May 2015 11:40 Go to previous messageGo to next message
BlackSwan
Messages: 26194
Registered: January 2009
Location: SoCal
Senior Member
post EXPLAIN PLAN for the SQL that throws this error.

does Cartesian product exist?
Re: Unable to extend temporary tablespace [message #636761 is a reply to message #636756] Fri, 01 May 2015 13:47 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Blackswan,

I generated the explain plan and saw the Cartesian join.
I gathered the stats on that table and it worked fine.

Thanks for you help.

Varun
Re: Unable to extend temporary tablespace [message #636765 is a reply to message #636755] Fri, 01 May 2015 14:53 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
ORA-20001: Unhandled Exception in PKG_TRANSFORM_WF.PR_WF_TRANS_ABL3.


Is this not a stupid message?
If it is a not handled exception then let it run, don't trap it to say it is not handled, this is obvious and just hide where the error comes from.
Read WHEN OTHERS.



Re: Unable to extend temporary tablespace [message #636766 is a reply to message #636765] Fri, 01 May 2015 15:07 Go to previous message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Thanks Michel.

Link was quite helpful
Previous Topic: Has Oracle certified RHEL 7.1 Version to install Oracle 11g R2 ?
Next Topic: ORA-16032
Goto Forum:
  


Current Time: Thu Oct 18 18:25:24 CDT 2018