1.查看某个时间点的表记录
select * from emp as of timestamp sysdate-1/48;--把结果查出来后,恢复就不成问题了。。。
2.查看表记录的更改记录
SELECT ID,
NAME,
VERSIONS_STARTTIME,
VERSIONS_ENDTIME,
VERSIONS_OPERATION FROM t VERSIONS BETWEEN TIMESTAMP MINVALUE
AND MAXVALUE
ORDER BY VERSIONS_STARTTIME DESC;
3.flashbck被drop掉的表
flashback table emp to before drop;