OraFAQ Forum: Server Administration » Unable to extend temporary tablespace

Home » RDBMS Server » Server Administration » Unable to extend temporary tablespace (11.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to extend temporary tablespace [message #636755]

Fri, 01 May 2015 11:32

varunvir
Messages: 389
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

Report message to a moderator

Re: Unable to extend temporary tablespace [message #636756 is a reply to message #636755]

Fri, 01 May 2015 11:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post EXPLAIN PLAN for the SQL that throws this error.

does Cartesian product exist?

Report message to a moderator

Re: Unable to extend temporary tablespace [message #636761 is a reply to message #636756]

Fri, 01 May 2015 13:47

varunvir
Messages: 389
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

Report message to a moderator

Re: Unable to extend temporary tablespace [message #636765 is a reply to message #636755]

Fri, 01 May 2015 14:53

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Unable to extend temporary tablespace [message #636766 is a reply to message #636765]

Fri, 01 May 2015 15:07

varunvir
Messages: 389
Registered: November 2007

Senior Member

Thanks Michel.

Link was quite helpful

Report message to a moderator

Previous Topic:	Has Oracle certified RHEL 7.1 Version to install Oracle 11g R2 ?
Next Topic:	ORA-16032

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:21:07 CST 2025