ORA-23346: primary key or object ID is undefined for table or materialized view string

ORA-23346: primary key or object ID is undefined for table or materialized view string
Cause: Trying to generate replication support for a table or materialized view without a primary key (as defined by a constraint or dbms_repcat.set_columns) or an object ID.
Action: For a table, add a primary key constraint or define a primary key using dbms_repcat.set_columns or use object tables. For a ROWID materialized view, set min_communication to false or use primary key or object ID materialized views.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-23346：主键或对象ID未定义为表或实例化视图字符串,
.原因：尝试为没有主键（由约束或dbms_repcat.set_columns定义）或对象ID的表或实例化视图生成复制支持。,
.操作：对于表，添加主键约束或使用dbms_repcat.set_columns或使用对象表定义主键。对于ROWID物化视图，将min_communication设置为false或使用主键或对象标识实例化视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-23346: primary key or object ID is undefined for table or materialized view string

1 个回答

相似问题