Re: SNAPSHOT ERROR

Posted by Arsalan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/SNAPSHOT-ERROR-tp1511p1517.html


Great sir

so when we create materialized view log it required primary key.. so if we don't want to add primary
key so what should we do ?



SQL> create materialized view log on abcd;
create materialized view log on abcd
*
ERROR at line 1:
ORA-12014: table 'ABCD' does not contain a primary key constraint