ORA-23415: materialized view log for "string"."string" does
not record the primary key



ORA-23415: materialized view log for "string"."string" does not record the prim..

Answer / guest

Cause: A primary key materialized view is being fast
refreshed, but the materialized view log does not record
primary key information.

Action: Use the CREATE MATERIALIZED VIEW LOG...ADD PRIMARY
KEY command to begin recording primary key information in
the materialized view log.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-34181: (MXCHGDCL21) workspace object is not a partitioned VARIABLE.

1 Answers  


ORA-00473: ARCH process terminated with error

1 Answers  


ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode

1 Answers  


SQL*Loader-00465: %s directive expects number arguments, number found.

1 Answers  


ORA-16206: database already configured as Logical Standby database

1 Answers  






SQL*Loader-00649: Quoted string missing closing quote

1 Answers  


ORA-01320: Invalid Logminer dictionar attribute

1 Answers  


ORA-19707: invalid record block number - string

1 Answers  


ORA-16074: ARCH processes must be active

1 Answers  


ORA-10617: Cannot create rollback segment in dictionary managed tablespace

1 Answers  


ORA-30485: missing ORDER BY expression in the window specification

1 Answers  


ORA-14029: GLOBAL partitioned index must be prefixed

1 Answers  


Categories