If you find that you cannot modify, delete, or manipulate a table, you can use the following statement to query whether the table is locked.
--Query lock
Select sess.sid,sess.serial#, Lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
From V$locked_object lo,dba_objects ao,v$session sess
where ao.object_id = lo.object_id
and lo.session_id = Sess.sid, where the SID and serial# fields are used for the following unlock statement, Oracle_username,os_user_name,object_name is the login name of the database, respectively. The user login role and the locked table name are logged in with the SYSDBA role to have permission to perform the following unlock operation, where the two numbers are the SID and serial# fields queried above, and a few are locked, to unlock a few to execute the corresponding few statements. --Unlock
Alter system kill session ' 208,44679 ';
Oracle Table Unlocking statements
