truncate or delete plan_table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: truncate or delete plan_table

Threaded View

  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.

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