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博客 ” ，链接：https://blog.itpub.net/30935525/viewspace-2123690/ ，如需转载，请注明出处，否则将追究法律责任。
