-
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!
-
if you have a transaction going (no commit or rollback is issued) then you cannot alter or drop a table
try commit then drop
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|