OraFAQ Forum: Server Administration » ORA-14450: attempt to access a transactional temp table already in use

Home » RDBMS Server » Server Administration » ORA-14450: attempt to access a transactional temp table already in use (oracle,10203,AIX) (

) 1 Vote

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

ORA-14450: attempt to access a transactional temp table already in use [message #331502]

Thu, 03 July 2008 12:17

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
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?

Report message to a moderator

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

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

Senior Member
Account Moderator

This smells the infamous autonomous transaction.

Regadrs
Michel

Report message to a moderator

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

monto
Messages: 60
Registered: November 2007
Location: DALLAS

Member

committed before alter statement but no use, got same error.

Report message to a moderator

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

BlackSwan
Messages: 26766
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)!

Report message to a moderator