![]() Owner object_name object_type CREATED LAST_DDL_TIME status OID D_OID Fair enough, this was a dev environment used only by me, so I used DBA_OBJECTS.OBJECT_ID to find out the object ID of that table: SQL> MYTABLE ![]() I can’t drop a table as someone is holding a lock on it. ORA-00054: resource busy and acquire with NOWAIT specified However I cancelled this command via pressing CTRL+C twice in Windows sqlplus (this actually just kills the client sqlplus and not the call).Īnyway, when I wanted to drop that table involved, this happened: SQL> drop table MYTABLE I had a following situation few days ago – I was running a CREATE TABLE AS SELECT over a heterogenous services dblink. Killing an Oracle process from inside Oracle Tanel Poder
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |