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

Thread: truncate or delete plan_table

Threaded View

  1. 11-11-2004, 04:05 PM #1
    jaya111
    jaya111 is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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