oracle 解锁
摘要:1.表级解锁:select 'alter system kill session ',''''||trim(t2.sid)||','||trim(t2.serial#)||''';'from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time执行查询的语句2.用户解锁ALTER USER username ACCOUNT UNLOCK;
阅读全文
posted @ 2013-02-27 12:44
浙公网安备 33010602011771号