-
truncate or delete plan_table
I try to delete plan_table . Its take a long time to delete from plan_table . Only 42 rews are in the plan_table. Then I cancel the statment and issue
truncate table plan_table;
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
Why I got this error?
Can anybody explain me?
Thanks
Last edited by jaya111; 11-11-2004 at 04:12 PM.
-
-
-
post the answer so other people can learn
Last edited by davey23uk; 11-11-2004 at 06:03 PM.
-
An explain plan is executed in another session, no commit is issued.
-
Another good reason to set up plan_table as a Global Temp Table.
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
|