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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 Answers  


ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label

1 Answers  


ORA-30191: missing argument list

1 Answers  


ORA-16086: standby database does not contain available standby log files

1 Answers  


ORA-14043: only one partition may be added

1 Answers  


ORA-24505: cannot change character set id on the handle

1 Answers  


ORA-28507: error in data dictionary view string

1 Answers  


RMAN-06000: could not open recovery manager library file: string

1 Answers  


ORA-12708: error while loading create database NLS parameter string

1 Answers  


ORA-39121: Table string can't be replaced, data will be skipped. Failing error is: string

1 Answers  


LRM-00103: 'string' contains an illegal integer radix for 'string'

1 Answers  


ORA-31523: could not find change source string for CDC change set string

1 Answers  


Categories