nowait 지정된 것 죽이기.. 시스템에서..

/* nowait 지정된것 찾기 */
SELECT A.SID, A.SERIAL#, B.TYPE, C.OBJECT_NAME
FROM V$SESSION A, V$LOCK B, DBA_OBJECTS C
WHERE A.SID=B.SID
AND B.ID1=C.OBJECT_ID
AND B.TYPE='TM'
AND C.OBJECT_NAME IN ('테이블명');

/* 세션죽이기 */
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';