Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

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

    Hello Friends

    I am getting this error -

    ERROR at line 1:
    ORA-00054: resource busy and acquire with NOWAIT specified

    while dropping a index. Does this mean that base table has been locked.
    Documentation says that wait for some time and retry. Can i get the scripts which tell me that what resources are locked.

    I m struck due to this error. Can u sugggest me the fastest way of getting out of this..

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Assuming that you've already done a search through this forum for locks & come up with some suitable hits (e.g. http://www.dbforums.com/showthread.p...ighlight=locks
    http://www.dbforums.com/showthread.p...ghlight=locks),

    what further information do you need?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •