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

Thread: NOWAIT specified

  1. 09-07-2001, 10:35 AM #1
    not_a_dba
    not_a_dba is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 09-07-2001, 10:10 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you have a transaction going (no commit or rollback is issued) then you cannot alter or drop a table

    try commit then drop
    Reply With Quote Reply With Quote
  3. 09-10-2001, 12:52 PM #3
    kris109's Avatar
    kris109
    kris109 is offline Professor Kris
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width