| dropping a user [message #59613] |
Sun, 07 December 2003 22:14  |
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.
|
|
|
|
| Re: dropping a user [message #59630 is a reply to message #59613] |
Wed, 10 December 2003 01:07  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
You get the ORA-14452 error because OTHER people (sessions) are using the temporary table. Best would be to ask them to log out until after you've created, dropped or altered the index.
$ oerr ora 14452
14452, 00000, "attempt to create, alter or drop an index on temporary table already in use"
// *Cause: An attempt was made to create, alter or drop an index on temporary
// table which is already in use.
// *Action: All the sessions using the session-specific temporary table have
// to truncate table and all the transactions using transaction
// specific temporary table have to end their transactions.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
