闪回表时候报错:
SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);
flashback table hr.employees to timestamp (systimestamp - interval '10' minute)
*
ERROR at line 1:
ORA-08189: cannot flashback the table because row movement is not enabled
开启行迁移
SQL> alter table hr.employees enable row movement;
Table altered.
SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);
Flashback complete.
阅读(1301) | 评论(0) | 转发(0) |