ORA-32422
commit SCN-based materialized view log cannot be created on table "string"."string" when there exist direct load/PMOP log entries for the table

Version

11.2

Cause

An attempt was made to create a commit SCN-based materialized view log on a table which had direct load/PMOP log entries in sys.sumdelta$ and sys.sumpartlog$.

Action

Refresh the table's dependent materialized views before creating commit SCN-based materialized view log on the table.

More Information

The Google Search results shown above are obtained by searching for this error using a custom google search engine which is restricted to a specific list of oracle reference sites. If you know a good oracle reference/help site and think that site should be included in this search, you can contribute to this search engine here.