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

注意:表闪回可在直接在open状态下操作

scn查找某一点的SCN:select timestamp_to_scn(to_timestamp('2012-12-30 10:36:14:477501','yyyy-mm-dd hh24:mi:ss:ff')) from dual;
获取当前的SCN:select systimestamp,timestamp_to_scn(sysdate) from dual; 
开始闪回:
flashback table table_name to scn scn_number;
报错error: ORA-08189: cannot flashback the table because row movement is not enabled.(ORA-08189: 因为未启用行移动功能, 不能闪回表。)
解决办法:
alter table table_name enable row movement;
再执行,操作完成。
原文地址:https://www.cnblogs.com/Jace06/p/8808784.html