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.
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.
create materialized view log on emp with rowid;
thanks my friend....more power to you
Click Here to Expand Forum to Full Width