| dropping user [message #59565] |
Thu, 04 December 2003 03:56  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi pls help me, i am getting the following error when i am trying to drop user with cascade command and also when i am trying to drop the table.
its a temp table.
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
any suggestions to how to drop the user or table.
pls help
|
|
|
|
| Re: dropping user [message #59567 is a reply to message #59565] |
Thu, 04 December 2003 04:19  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
|
ur dropping the user account whose table has been having references to those tables which has been stored in other user account so first drop all the foriegn keys of tables then drop the user this will work
|
|
|
|
|
|
| Re: dropping user [message #61604 is a reply to message #59582] |
Mon, 10 May 2004 00:02 |
Michael Schindler
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
It is possible that this is due to bug 1055420 where after a session inserting into a global temporary table is killed, another session is unable to drop the global temporary table and encounters ORA-14452.
The bug is fixed in Oracle9i, Release 2. Restarting the database should clear it up and is the workaround.
|
|
|
|
| Re: dropping user [message #61605 is a reply to message #61604] |
Mon, 10 May 2004 00:08 |
Michael Schindler
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
I forgot to mention:
you can rename the table if you do not want to restart now and it is in the way. However this will not allow dropping of the user (you'll get the same error on the renamed table)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
