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

ORA-27414: Invalid BY value type

1 Answers  


IMG-00856: adjacency matrix free failed

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


ORA-31654: unable to convert file or volume size as specified to a number

1 Answers  


ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.

1 Answers  


PLS-00621: at least one operand in the COALESCE expression must not be NULL

1 Answers  


SQL*Loader-00420: unsupported datatype conversion requested for column string in table string

1 Answers  


ORA-13855: Tracing for service (module/action) string on instance string is already enabled

1 Answers  


ORA-02777: Stat failed on log directory

1 Answers  


ORA-30507: normal triggers cannot be based on a schema or a database

1 Answers  


ORA-16004: backup database requires recovery

1 Answers  


ORA-26527: local store callback init phase failed for 'string.string'

1 Answers  


Categories