oralce 恢复Delete删除

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

select * from db_datatable as of timestamp to_timestamp('2014-05-19 18:00:52','yyyy-mm-dd hh24:mi:ss');

alter table db_datatable enable row movement;

flashback table db_datatable to timestamp to_timestamp('2014-05-19 18:00:52','yyyy-mm-dd hh24:mi:ss');

 

 

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;

flashback table "BIN$GiAaiQX+SJGgAURNI6vv2A==$0" to before drop;