DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.