DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: truncate or delete plan_table

  1. #1
    Join Date
    Oct 2004
    Posts
    8

    Question 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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    tahiti.oracle.com
    Jeff Hunter

  3. #3
    Join Date
    Oct 2004
    Posts
    8
    I got my answer

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    post the answer so other people can learn
    Last edited by davey23uk; 11-11-2004 at 06:03 PM.

  5. #5
    Join Date
    Apr 2003
    Posts
    353
    An explain plan is executed in another session, no commit is issued.

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
  •  


Click Here to Expand Forum to Full Width