1.当在开发测试时,误删除数据,如想恢复,可立即
alter table table_name enable row movement;
flashback table table_name to timestamp
to_timestamp('2008070816','yyyymmddhh24');
alter table table_name enable row movement;
flashback table table_name to timestamp
to_timestamp('2008070816','yyyymmddhh24');