-
snapshot logs
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.
-
Code:
create materialized view log on emp with rowid;
-
thanks my friend....more power to you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|