snapshot logs

[rommel]

Hi friends,

In prevoius oracle db versions, i can create a snapshot log
for a certain table based w/o primary key or by using the rowid.

Example.

SQL> create snapshot log on EMP;
ORA-12014: table 'EMP' does not contain a primary key constraint

I always use this to store dml changes made against the table,
while i am rebuilding/reorganizing it (based of rowid) and apply
the changes after.

Can u help me the new command to create a snapshot log based on
a rowid pls?

Thank u all in advance.

[slimdave]

create materialized view log on emp with rowid;

[rommel]

thanks my friend....more power to you