-
ORA-14450: attempt to access a transactional temp table already in use
Hi Gurus,
I need to alter the global temp. table but its not letting me alter it
and throwing the below error,i tried few times at regular interval but no use,is there a way to find out who is actually using it?
ERROR at line 1:
ORA-14450: attempt to access a transactional temp table already in use
Any suggestion would be great.
AIX-5.1
10.2.03
-
do not attempt to access the temporary table until the concurrent transaction has committed or aborted.
The table is in use
-
Cause
~~~~~~~
If the global temporary table was created with "on commit preserve rows" option,
the global temp table would still be locked eventhough transaction was commited.
Fix
~~~~
+ Disconnect and connect the session
the metalink says..
https://metalink.oracle.com/metalink...,1,1,helvetica
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|