–创建测试表
create table flash_test as
select * from dba_objects where object_type=‘TABLE’ and OWNER like ‘%SYS%’;
–查询表的数据的存储时间
select sysdate from dual; --2020-12-02 19:17:38
–删除表的数据
delete from flash_test;
–确认删除有效
select * from flash_test;
–提交确认
commit
–执行查询,查看指定时间的时候的对应记录
select count(*) from flash_test as of timestamp to_timestamp(‘2020-12-02 19:18:48’,‘yyyy-mm-dd hh24:mi:ss’);
–执行闪回,初步会出现报错
flashback table flash_test to timestamp to_timestamp(‘2020-12-02 19:18:48’,‘yyyy-mm-dd hh24:mi:ss’);
–修改表允许行移动
alter table flash_test1 enable row movement;
–执行闪回
flashback table flash_test1 to timestamp to_timestamp(‘2020-12-02 19:14:37’,‘yyyy-mm-dd hh24:mi:ss’);
–查询结果
select * from flash_test;