Home » RDBMS Server » Server Administration » ORA-14450: attempt to access a transactional temp table already in use (oracle,10203,AIX)  () 1 Vote
ORA-14450: attempt to access a transactional temp table already in use [message #331502] Thu, 03 July 2008 12:17 Go to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Hi ,
I need to alter the global temp. table but its not letting me alter itand throwing the below error,i tried few times at regular (last 3 days)interval but no use,is there a way to find out who is actually using it?i tried seeing it through v$access for the object but i found nothing or how to kill the sesion which is using it or holding up or is there a option of commiting it or do rollback.


ERROR at line 1:
ORA-14450: attempt to access a transactional temp table already in use

Any suggestion would be great.

Re: ORA-14450: attempt to access a transactional temp table already in use [message #331504 is a reply to message #331502] Thu, 03 July 2008 12:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

As Pogo once said, "We have met the enemy, and they is us!".

14450, 00000, "attempt to access a transactional temp table already in use"
// *Cause:  An attempt was made to access a transactional temporary table that
//          has been already populated by a concurrent transaction of the same
//          session.
// *Action: do not attempt to access the temporary table until the
//          concurrent transaction has committed or aborted.


What happens if/when you issue a COMMIT or ROLLBACK just before the ALTER?
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331507 is a reply to message #331502] Thu, 03 July 2008 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This smells the infamous autonomous transaction.

Regadrs
Michel
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331514 is a reply to message #331504] Thu, 03 July 2008 13:20 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
committed before alter statement but no use, got same error.
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331515 is a reply to message #331502] Thu, 03 July 2008 13:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Since you decided to not read or follow Posting Guideline, I have decided to allow you to resolve this situation without me wasting more time on it.

You're On Your Own (YOYO)!
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331517 is a reply to message #331502] Thu, 03 July 2008 13:39 Go to previous messageGo to next message
monto
Messages: 60
Registered: November 2007
Location: DALLAS
Member
Can you please let me know what is that i violated here,so that i can be really careful with it next time Smile
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331519 is a reply to message #331514] Thu, 03 July 2008 13:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 03 July 2008 19:41
This smells the infamous autonomous transaction.

Regadrs
Michel


Re: ORA-14450: attempt to access a transactional temp table already in use [message #331520 is a reply to message #331502] Thu, 03 July 2008 13:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Subject: ORA-14450 Attempt to access a transactional temp table already in use
Doc ID: Note:252091.1
Re: ORA-14450: attempt to access a transactional temp table already in use [message #331522 is a reply to message #331520] Thu, 03 July 2008 14:17 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Useful note indeed.

Regards
Michel
Previous Topic: Unique index question
Next Topic: transportable tablespace with IOT
Goto Forum:
  


Current Time: Wed Dec 07 10:37:56 CST 2016

Total time taken to generate the page: 0.12041 seconds