(1)对表进行恢复
delete from emp --对表进行删除
grant flashback any table to system;--授予权限alter table emp enable row movement;--启用表emp的行移动
flashback table emp to timestamp to_timestamp('2016-05-19 19:30:00','yyyy-mm-dd hh24:mi:ss')
--对表进行恢复
select * from emp--对表查询
(2)对表进行解锁
1.对表解锁,处理,可能用当前账号,或者是用超级账号解锁
SELECT T.SID,T.SERIAL#,T.USERNAME, T.LOCKWAIT, T.STATUS, T.MACHINE, T.PROCESS
FROM V$SESSION T
WHERE T.SID IN (SELECT SESSION_ID FROM V$LOCKED_OBJECT)
SELECT * FROM V$SESSION
ALTER SYSTEM KILL SESSION '145,715';