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

Thread: NOWAIT specified

  1. #1
    Join Date
    Jun 2001
    Posts
    5
    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).
    Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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
    Location
    San Francisco, California
    Posts
    510
    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