表解锁表解锁

如何解决表被锁定的问题

SQL> select username,status,sid,serial# from v$session where username is not null;

USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
SYS ACTIVE 11 38493

SQL> /

USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP INACTIVE 9 38038
SYS ACTIVE 11 38493

SQL> alter system kill session '9,38038';

系统已更改。

SQL> select username,status,sid,serial# from v$session where username is not null;

USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP KILLED 9 38038
SYS ACTIVE 11 38493

SQL>