ORA-08189: cannot flashback the table because row movement is not enabled

2014-11-24 17:33:47 · 作者: · 浏览: 1

闪回表时候报错:


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.


相关阅读