Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: Problem with Droping index

    Hello OracleDBAs,
    Iam trying to drop an index defined on a table.It gives me the following error.
    "ORA-00054: resource busy and acquire with NOWAIT specified"
    Is there any way I can drop the index forcefully...so that I can proceed with my work.
    Please help me..
    Thanks in advance.
    sridhar

  2. #2
    Join Date
    Aug 2004
    Posts
    9
    No. You will need to stop the operations on the table that use the index and then drop it.

Posting Permissions

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