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

Thread: resource busy

  1. 06-05-2004, 02:33 AM #1
    Rangi
    Rangi is offline Junior Member
    Join Date
    Jan 2004
    Posts
    25

    resource busy

    Hi All,

    I got the following err msg when i tried to drop a table.

    ORA-00054: resource busy and acquire with NOWAIT specified.

    Can anyone let me know that what would be the reason.

    Thanx in advance.
    Reply With Quote Reply With Quote
  2. 06-05-2004, 02:34 AM #2
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    RTM ( Concepts and Error Messages )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  3. 06-07-2004, 11:57 AM #3
    tamilselvan
    tamilselvan is offline Senior Advisor
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When the resource (Table) is being used by other sessions, you tried to drop the table. That is why you got 54 error.

    To avoid the error, you first lock the table in exclusive mode, and then drop it.

    SQL> lock table t1 in exclusive mode ;

    Table(s) Locked.

    SQL> drop table t1;

    Table dropped.

    Tamil
    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