Wednesday, April 04, 2007

ORA-14450: attempt to access a transactional temp table already in use

I got this Oracle Error while executing an Alter Table Drop Column statement, because the table is still in use, the Drop column will not continue, I had to wait until all sessions for my schema disconnect.

The sessions can be shown in Oracle Enterprise Manager, if you are in a development environment or you have enough authority ... you can Kill the active sessions :),295199,sid63_gci1223614,00.html

No comments: