恢复采用create table scfecbzxdy_zzc as SELECT * FROM scfecbzxdy AS OF TIMESTAMP SYSDATE-1/24 ;这样的SQL恢复的。
select * from t as of timestamp to_timestamp(‘2010-06-29 22:57:47’, ‘yyyy-mm-dd hh24:mi:ss’);
恢复oracle中用pl sql误删除drop掉的表
查看回收站中表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
恢复表
SQL>flashback table test_drop to before drop;或
SQL>flashback table “BIN b