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

Thread: NOWAIT specified

  1. #1
    Join Date
    Jun 2001
    I have a TEMP table I populate and then delete from after the query is run. I want to delete the table, but get the following message: VBO:4562 - table cannot be dropped ORA_00054 resource busy and acquired with NOWAIT specified. How can I amend this and drop the table (I cannot currently even delte a record from the table).

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    if you have a transaction going (no commit or rollback is issued) then you cannot alter or drop a table

    try commit then drop

  3. #3
    Join Date
    May 2001
    San Francisco, California
    If you kill the session, PMON should clean up after the session and release all the locks. Try this and open a fresh session, if commit and rollback does not work. Sometimes, objects such as views become invalid if there is a deadlock situation. Recompile them and the error will go away.

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