i am getting this ( ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired) error when I try to drop a table and when I try this
(
SELECT B.OWNER, B.OBJECT_NAME, A.ORACLE_USERNAME, A.OS_USER_NAME
FROM V$LOCKED_OBJECT A, ALL_OBJECTS B
WHERE A.OBJECT_ID = B.OBJECT_ID;
)query to find the session causing the problem I get an error saying table does not exist. any suggestions on how I can unlock the table/