Re: SNAPSHOT ERROR

Posted by ErmanArslansOracleBlog on Nov 08, 2016; 7:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/SNAPSHOT-ERROR-tp1511p1518.html

Cause:  The CREATE MATERIALIZED VIEW LOG command was issued with the WITH
        PRIMARY KEY option and the master table did not contain a primary key
        constraint or the constraint was disabled.
Action: Reissue the command using only the WITH ROWID option, create a primary
        key constraint on the master table, or enable an existing primary key
        constraint.

Example:

SQL> create materialized view log on M1 with ROWID;