表被锁定的解决办法(1)

打开Dev PL/Sql Developer的命令窗口，然后进行如下操作

SQL> SELECT object_name, s.username, s.sid, s.serial#, p.spid, to_char(s.logon_time,'yyyy-mm-dd hh24:mi:ss') logon_time
  2      FROM   v$locked_object l, dba_objects o, v$session s, v$process p
  3      WHERE  l.object_id = o.object_id
  4                 AND l.session_id = s.sid
  5                 AND s.paddr = p.addr;
 
OBJECT_NAME                                                                      USERNAME                              SID    SERIAL# SPID         LOGON_TIME
-------------------------------------------------------------------------------- ------------------------------ ---------- ---------- ------------ -------------------
T_NOT_COMP_SAMPLE                                                                BAOSIGHT                              355      30231 4712         2011-11-15 16:07:34
T_SAMPLE                                                                         BAOSIGHT                              355      30231 4712         2011-11-15 16:07:34
 
SQL> select OWNER,INDEX_NAME,TABLE_NAME,INDEX_TYPE from dba_indexes where INDEX_NAME like '%T_SAMPLE%';
 
OWNER                          INDEX_NAME                     TABLE_NAME                     INDEX_TYPE
------------------------------ ------------------------------ ------------------------------ ---------------------------
BAOSIGHT                       T_STDSAMPLE_A_UK20110727       T_STDSAMPLE_AREA               NORMAL
  
SQL> alter system kill session '355,30231';
 
System altered
 
SQL> alter session set current_schema=BAOSIGHT;
 
Session altered

注意：每个命令必须以分号结束，回车后才会执行命令。