Flashback Query简单一列——delete数据恢复

1. 创建测试表

 

SQL> create user test identified by test;   User created.   SQL> grant connect , resource to test;   Grant succeeded.   SQL> create table test.t1 as select * from dba_users;   Table created.   SQL> select count(*) from test.t1;     COUNT(*) ----------         32

 

2. delete几行数据

 

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';   Session altered.   SQL> select sysdate from dual;   SYSDATE ------------------- 2016-08-18 01:10:54   SQL> delete from test.t1 where rownum<6;   5 rows deleted.   SQL> commit;   Commit complete.   SQL> select count(*) from test.t1;     COUNT(*) ----------         27

 

3. 通过闪回查询指定时间点（或SCN）

 

SQL> select count(*) from test.t1  as of timestamp to_timestamp(' 2016-08-18 01:10:54','yyyy-mm-dd hh24:mi:ss');     COUNT(*) ----------         32

 

（可从闪回查询的结果恢复数据）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30935525/viewspace-2123690/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30935525/viewspace-2123690/