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!