SELECT OBJECT_NAME,ORIGINAL_NAME,TYPE,CREATETIME,DROPTIME FROM RECYCLEBIN A
WHERE A.ORIGINAL_NAME = ‘TABLE_NAME’;
flashback table TABLE_NAME to before drop;
查询某个时间点的数据
select * from TABLE_NAME
as of timestamp to_timestamp(‘2021-03-21 06:40:00’,‘yyyy-mm-dd hh24:mi:ss’)
找回数据到某个时间的数据
alter table TABLE_NAME enable row movement; /启动闪回功能/
flashback table TABLE_NAME to timestamp to_timestamp(‘2021-03-21 06:40:00’,‘YYYY-MM-DD HH24:MI:SS’); /回退数据/