表的解锁

1.查询被锁定的表

select b.owner, b.object_name, a.*
  from v$locked_object a, dba_objects b
 where a.object_id = b.object_id;

2.查询出sid和serial

select sid, serial#, username, osuser from v$session; 

3.解锁

alter system kill session 'sid,serial#';