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-00369: Current log of thread string not useable and other log being cleared

1 Answers  


ORA-12681: Login failed: the SecurID card does not have a pincode yet

1 Answers  


QSM-02150: select lists must be identical across the UNION operator

1 Answers  


NNL-00270: Current default domain is "string"

1 Answers  


NNL-00202: No shutdown currently scheduled

1 Answers  






NNL-00521: Shows or sets the server's system query forwarding requirements

1 Answers  


ORA-31441: table is not a change table

1 Answers  


ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop change tables

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


LSX-00153: invalid combination of default and fixed attributes

1 Answers  


TNS-04086: Invalid value for the event string.

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


Categories