oracle表数据删除后恢复

select * from SYS_ORGANIZATION as of timestamp to_timestamp('2020-4-14 9:10:00','yyyy-mm-dd hh24:mi:ss');
alter table SYS_ORGANIZATION enable row movement;
flashback table SYS_ORGANIZATION to timestamp to_timestamp('2020-4-14 9:10:00','yyyy-mm-dd HH24:MI:SS');

注：时间设为删除表数据之前的大概时间！

posted on 2020-04-14 09:23 斑驳。阅读(701) 评论(0) 编辑收藏举报