1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');
2.如果报错 ORA-08189: cannot flashback the table because row movement is not enabled
3.alter table table_test enable row movement;
4.OK
本文介绍如何使用Flashback功能恢复Oracle数据库中的表到指定的时间戳。包括执行Flashback表命令的具体语法,解决因未启用行移动而产生的ORA-08189错误的方法。
1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');
2.如果报错 ORA-08189: cannot flashback the table because row movement is not enabled
3.alter table table_test enable row movement;
4.OK

被折叠的 条评论
为什么被折叠?