ORA-12041: cannot record ROWIDs for index-organized table "string"."string"

ORA-12041: cannot record ROWIDs for index-organized table "string"."string"
Cause: Index-organized tables do not have ROWIDs. Therefore a materialized view log that records the ROWIDs of an index-organized table could not be created.
Action: Do not include the WITH ROWID option when using the CREATE MATERIALIZED VIEW command and do not include the ADD ROWID option when using the ALTER MATERIALIZED VIEW command if the master table is index-organized.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12041：不能记录索引组织表“ string ”的ROWID 。“ string ”,
.原因：索引组织的表没有ROWID。因此，无法创建记录索引组织表的ROWID的实例化视图日志。,
.操作：在使用CREATE MATERIALIZED VIEW命令时，不要包括WITH ROWID选项，如果主表是索引组织的，则在使用ALTER MATERIALIZED VIEW命令时不要包括ADD ROWID选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-12041: cannot record ROWIDs for index-organized table "string"."string"

1 个回答

相似问题