oracle 删除表以及回复数据

找回删除的表

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin WHERE original_name = 'T_WX_ACCOUNT_INFO'
flashback table "BIN$uJdPCiHKTzbgUwEAAH/FvA==$0" to before drop;

找回删除的数据

select dbms_flashback.get_system_change_number from dual;

1. 获得当前SCN

获取scn 编号54004885
select dbms_flashback.get_system_change_number from dual;
查看当前的csn编号下面的数据是否全部都在
select count(*) from  T_TABLE as of scn 54004885;

2. 恢复数据

按照scn进行数据恢复
insert into T_TABLE select * from T_TABLE  as of scn 54004885;