oracle 恢复delete数据

 

--1.基于 AS OF TIMESTAMP

--查找 tablename 在某一个时刻下数据

SELECT * FROM tablename AS OF TIMESTAMP TO_TIMESTAMP('2010-12-15 11:10:17', 'YYYY-MM-DD HH:MI:SS') 


--例如插入某表五分钟前时刻数据
INSERT INTO tablename SELECT * FROM tablename AS OF TIMESTAMP SYSDATE-5/1440
--1440=60分钟*24小时 详细看

--http://blog.csdn.net/zhouwubin123/article/details/6617837

2.基于 AS OFＳＣＮ

--http://blog.sina.com.cn/s/blog_6d6e54f70100z7yd.html

Oracle闪回技术详解

--https://www.cnblogs.com/chengxiao/p/5860823.html