闪回表时候报错:
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.
相关阅读:
关于ORA-01000: maximum open cursors exceeded" 问题分析总结
关于Oracle游标的问题(ORA-01000: maximum open cursors exceeded)
Oracle ORA-01000:maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded