1、确保数据库启用了 闪回 功能:
db_recovery_file_dest string /opt/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
db_flashback_retention_target integer 1440
2、在表上启用 行迁移 :
alter table t_xxxxxx enable row movement;
3、闪回到某时间点:
flashback table t_xxxxxx to timestamp to_timestamp('2012-05-31 16:20:30', 'yyyy-mm-dd hh24:mi:ss');
db_recovery_file_dest string /opt/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 2G
db_flashback_retention_target integer 1440
2、在表上启用 行迁移 :
alter table t_xxxxxx enable row movement;
3、闪回到某时间点:
flashback table t_xxxxxx to timestamp to_timestamp('2012-05-31 16:20:30', 'yyyy-mm-dd hh24:mi:ss');