闪回操作
2019-03-06 本文已影响0人
蚁丶点
闪回表数据
先让row_movement可编辑
select row_movement from user_tables where table_name='STUDENT';
alter table STUDENT enable row movement;
闪回
flashback table student to timestamp to_timestamp('2018-12-17 14:28:33','yyyy-mm-dd hh24:mi:ss');
删除表后闪回
flashback table STUDENT to before drop;