oracle 数据闪回

来源:互联网 发布:js中的事件冒泡 编辑:程序博客网 时间:2024/05/17 07:48
select * from scott.dept
insert into scott.dept values(50,'错误数据','CHINA');
select * from scott.dept as of timestamp to_timestamp('2011-12-09 10:00:00','yyyy-mm-dd hh24:mi:ss');

alter table scott.dept enable row movement
flashback table scott.dept to timestamp to_timestamp('2011-12-09 10:00:00','yyyy-mm-dd hh24:mi:ss');
select * from scott.dept as of timestamp to_timestamp('2011-12-09 10:00:00','yyyy-mm-dd hh24:mi:ss');
alter table scott.dept enable row movement
flashback table scott.dept to timestamp to_timestamp('2011-12-09 10:00:00','yyyy-mm-dd hh24:mi:ss');
原创粉丝点击