--DROP 表恢复方式
FLASHBACK TABLE EI.TZ_T_PROJ_INFO TO BEFORE DROP
--delete 数据恢复方式
//1.先确认下数据库时间和本地时间误差
select to_char(sysdate,'yy-mm-dd hh24:mi:ss') time from dual;
//2.查询各个时间点的删除数据信息
select * from CI.LOAN_T_REPAY_REC_CHECK AS OF timestamp(to_timestamp ('11/03/2015 14:20:00','mm/dd/yyyy hh24:mi:ss'));
//3.开启 row movmment
alter table CI.LOAN_T_REPAY_REC_CHECK enable row movement;
//4.恢复到指定时间节点
flashback table CI.LOAN_T_REPAY_REC_CHECK to timestamp
to_timestamp ('11/03/2015 14:00:00','mm/dd/yyyy hh24:mi:ss');
FLASHBACK TABLE EI.TZ_T_PROJ_INFO TO BEFORE DROP
--delete 数据恢复方式
//1.先确认下数据库时间和本地时间误差
select to_char(sysdate,'yy-mm-dd hh24:mi:ss') time from dual;
//2.查询各个时间点的删除数据信息
select * from CI.LOAN_T_REPAY_REC_CHECK AS OF timestamp(to_timestamp ('11/03/2015 14:20:00','mm/dd/yyyy hh24:mi:ss'));
//3.开启 row movmment
alter table CI.LOAN_T_REPAY_REC_CHECK enable row movement;
//4.恢复到指定时间节点
flashback table CI.LOAN_T_REPAY_REC_CHECK to timestamp
to_timestamp ('11/03/2015 14:00:00','mm/dd/yyyy hh24:mi:ss');
时间不能过去太久