dropping a user [message #59583] |
Thu, 04 December 2003 21:05 |
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
table hasnt got any constraints defined on it
any suggestions to how to drop the user or table.
thanx in advance
|
|
|
Re: dropping a user [message #59584 is a reply to message #59583] |
Thu, 04 December 2003 23:03 |
dilip kumar
Messages: 111 Registered: December 2003
|
Senior Member |
|
|
hi sam i got ur problem see u have created that temp table with on commit preserve rows and any table created with that option and if u access the table it contains the data for that session
so u end the transaction implicitly/explicitly
eg issue truncate/commit
then drop the table and user as well
|
|
|
Re: dropping a user [message #59586 is a reply to message #59584] |
Thu, 04 December 2003 23:46 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
hi thanx but that doesnt solve my problem.
there r no transactions in v$transaction.
can u elobarate and let me what can i do now.
regards
|
|
|
|
Re: dropping a user [message #59609 is a reply to message #59588] |
Sun, 07 December 2003 20:00 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
hi,
i truncated, no rows in the table.
i tried to end the transaction by committing and by rollback aswell.
but it still gives the following error
ORA-14452: attempt to create, alter or drop an index on temporary table already
in use.
help me
thanx in advance.
|
|
|