原因:有其他用户锁住了这张表
解决办法:
(1) select SESSION_ID from v$locked_object l join dba_objects o on (l.OBJECT_ID=o.object_id) where o.object_name='表名(注意大写)'
(2) select * from v$session where sid=?
(3) alter system kill session 'sid的值,serial#的值';
原因:有其他用户锁住了这张表
解决办法:
(1) select SESSION_ID from v$locked_object l join dba_objects o on (l.OBJECT_ID=o.object_id) where o.object_name='表名(注意大写)'
(2) select * from v$session where sid=?
(3) alter system kill session 'sid的值,serial#的值';