ORA-12031: cannot use primary key columns from materialized
view log on "string"."string"



ORA-12031: cannot use primary key columns from materialized view log on "string"."st..

Answer / guest

Cause: The materialized view log either did not have primary
key columns logged, or the timestamp associated with the
primary key columns was more recent than the last refresh time.

Action: A complete refresh is required before the next fast
refresh. Add primary key columns to the materialized view
log, if required.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

TNS-12223: TNS:internal limit restriction exceeded

1 Answers  


ORA-29528: invalid Java call in trigger string

1 Answers  


ORA-02431: cannot disable constraint (string) - no such constraint

1 Answers  


ORA-01183: cannot mount database in SHARED mode

1 Answers  


TNS-12529: TNS:connect request rejected based on current filtering rules

1 Answers  


ORA-16727: resource guard cannot close database

1 Answers  


ORA-12003: materialized view "string"."string" does not exist

1 Answers  


NNL-00210: Cache checkpointing is currently disabled

1 Answers  


ORA-02334: cannot infer type for column

1 Answers  


ORA-01481: invalid number format model

1 Answers  


ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


Categories