基本闪回查询
select * from t1
as of timestamp to_timestamp('2015-05-26 22:04:08','yyyy-mm-dd hh24:mi:ss');
或者
select * from t1
as of timestamp current_timestamp - interval '15' minute;
查询误删除的数据
select * from t1
as of timestamp to_timestamp('2015-05-26 22:04:08','yyyy-mm-dd hh24:mi:ss')minus
select * from t1;
将会话设置在固定的时间
execute dbms_flashback.enable_at_time(to_timestamp('2015-05-26 22:04:08','yyyy-mm-dd hh24:mi:ss'));
execute dbms_flashback.disable;
闪回表
alter table t1 enable row movement;
alter table t2 enable row movement;
flashback table t1,t2 to timestamp to_timestamp('2015-05-26 22:35:08','yyyy-mm-dd hh24:mi:ss');
flashback table t1,t2 to timestamp current_timestamp- interval '10' minute;
--转自
当前位置：
论坛首页 »
自由讨论区 »
MySQL, Oracle及数据库讨论区
»
发起投票
技术讨论
加好友
发消息
2015-8-13 15:35:12 |
赞(
操作
