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-00316: log string of thread string, type string in header is not log file

1 Answers  


ORA-01195: online backup of file string needs more recovery to be consistent

1 Answers  


ORA-28009: connection to sys should be as sysdba or sysoper

2 Answers  


RMAN-06140: cannot specify TAG option with LIST INCARNATION

1 Answers  


ORA-29339: tablespace block size string does not match configured block sizes

1 Answers  


ORA-14110: partitioning column may not be of type ROWID

1 Answers  


ORA-07671: $IDTOASC failed translating an integrity category

1 Answers  


LPX-00653: Output attribute '~S' doesn't have a parent element.

1 Answers  


EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported

2 Answers  


RMAN-06416: PROXY ONLY was specified and some files could not be proxy copied

1 Answers  


PLW-05000: mismatch in NOCOPY qualification between specification and body

1 Answers  


RMAN-20218: datafile not found in recovery catalog

1 Answers  


Categories