ORA-14550错误解决方法
工作中修改临时表,报错:
----------------------------------
以SYSDBA身份登录,执行以下语句:
select a.sid, a.serial#,
a.paddr, 'alter system kill session ''' || a.sid || ',' || a.serial# || ''';' AS kill_session
FROM v$session a
WHERE a.sid in (select sid from v$enqueue_lock t where t.type='TO');
执行查询出的语句。
--------------------------
present by dylan.