ITPub博客

首页 > 数据库 > Oracle > ORA-08189

ORA-08189

原创 Oracle 作者:xing2999 时间:2011-11-20 20:44:29 0 删除 编辑

[oracle@lonion ~]$ oerr ora 08189

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

ORA-08189:不能闪回表,因为未启用行移动功能

08189, 00000, "cannot flashback the table because row movement is not enabled"

// *Cause: An attempt was made to perform Flashback Table operation on a table for which row movement has not been enabled. Because the Flashback Table does not preserve the rowids, it is necessary that row movement be enabled on the table.

// *Action: Enable row movement on the table

解决方法:

SQL> alter table table_name enable row movement ;

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24389441/viewspace-1056416/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 临时表
下一篇: ORA-00845
请登录后发表评论 登录
全部评论

注册时间:2010-09-29

  • 博文量
    42
  • 访问量
    148198