ORA-12014: table 'string' does not contain a primary key constraint

ORA-12014: table 'string' does not contain a primary key constraint
Cause: The CREATE MATERIALIZED VIEW LOG command was issued with the WITH PRIMARY KEY option and the master table did not contain a primary key constraint or the constraint was disabled.
Action: Reissue the command using only the WITH ROWID option, create a primary key constraint on the master table, or enable an existing primary key constraint.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:40

ORA-12014：表' 串 '不包含一个主键约束,
.原因：发出带有WITH PRIMARY KEY选项的CREATE MATERIALIZED VIEW LOG命令，并且主表不包含主键约束或禁用约束。,
.操作：仅使用WITH ROWID选项重新发出命令，在主表上创建主键约束或启用现有主键约束。,
.

aiaiDBA

13718043309

010-86462881

ORA-12014: table 'string' does not contain a primary key constraint

1 个回答

相似问题