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-29301: wrong DBMS_PITR package function/procedure order

1 Answers  


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-24150: evaluation context string.string does not exist

1 Answers  


AMD-00122: dimension #string: analytic workspace hierarchy dimension not specified

1 Answers  


ORA-36402: (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.

1 Answers  


RMAN-06587: one or more datafilecopies were not found

1 Answers  


RMAN-06597: conversion between platforms 'string' and 'string' is not implemented

1 Answers  


ORA-12047: PCT FAST REFRESH cannot be used for materialized view "string"."string"

1 Answers  


ORA-04007: MINVALUE cannot be made to exceed the current value

1 Answers  


ORA-30464: no summaries exist

1 Answers  


KUP-04056: internal error: OCI error while fetching record: number

1 Answers  


ORA-03297: file contains used data beyond requested RESIZE value

1 Answers  


Categories