oracle 中 drop表 试图删除正在使用的临时表,ora-14452 试图创建,更改或删除正在使用的临时表中的索引...

-- 查看与此临时表相关的会话，并Kill掉!20101015测试通过

-- 操作如下 ：

--查询所有的死锁：

SELECT * FROM V$LOCK;

--查询所有的会话：

SELECT * FROM V$SESSION;

--查询所有的死锁的会话：

SELECT SN.SID,

SN.SERIAL#,

SN.USERNAME,

SN.MACHINE,

SN.TERMINAL,

SN.PROGRAM,

SN.TYPE

FROM V$SESSION SN

WHERE SN.SID IN (SELECT LK.SID FROM V$LOCK LK);

------------------------------------------------------------

SELECT 'ALTER SYSTEM KILL SESSION '''||SN.SID||','||SN.SERIAL#||''';'

FROM V$SESSION SN

WHERE SN.SID IN (SELECT LK.SID FROM V$LOCK LK);

ALTER SYSTEM KILL SESSION '1266,3834';

ALTER SYSTEM KILL SESSION '1282,2303';

ALTER SYSTEM KILL SESSION '1494,1';

ALTER SYSTEM KILL SESSION '1495,1';

ALTER SYSTEM KILL SESSION '1496,1';

ALTER SYSTEM KILL SESSION '1497,1';

--杀掉死锁会话：

ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

ALTER SYSTEM KILL SESSION '1323,13189';ALTER SYSTEM KILL SESSION '1350,27497';ALTER SYSTEM KILL SESSION '1367,13850';ALTER SYSTEM KILL SESSION '1369,14223';ALTER SYSTEM KILL SESSION '1440,6115';ALTER SYSTEM KILL SESSION '1469,20601';ALTER SYSTEM KILL SESSION '1478,21239';ALTER SYSTEM KILL SESSION '1494,1';ALTER SYSTEM KILL SESSION '1495,1';ALTER SYSTEM KILL SESSION '1496,1';ALTER SYSTEM KILL SESSION '1497,1';