回收站(recyclebin)及回滚 - Oracle-fans - 博客园

1、

alter table table_name enable row movement;

flashback table table_name  to timestamp  to_timestamp('2017-09-25','yyyy-mm-dd hh24:mi:ss');

alter table table_name disable row movement;

2、

select * from table_name as of timestamp to_timestamp('2017-09-25','yyyy-mm-dd hh24:mi:ss');