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

Thread: resource busy

  1. #1
    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.

  2. #2
    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"

  3. #3
    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

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