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

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

Question Posted / guest

1 Answers
7160 Views
I also Faced
E-Mail Answers

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