Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-12031

cannot use primary key columns from materialized view log on "string"."string"

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.