Oracle恢复删除的数据

insert into cd_access_right
  select *
    from (select *
            from cd_access_right as of timestamp to_timestamp('2009-8-2 16:42:50', 'yyyy-mm-dd hh24:mi:ss'));

评论

2 楼 javatozhang 2012-11-22  

能附带解释吗？让我们这些初出茅庐的人看个明白。期待着你的回答。

1 楼 luoyu-ds 2012-11-21  

我也写一个：
alter table table_name enable row movement;
flashback table table_name to timestamp to_timestamp('20120321 14:00:00','yyyymmdd hh24:mi:ss');