Sai
Complete refresh always
truncates the table and then does an insert.
However there is trick - if
you create a refresh group (even if it contains just one snapshot) and refresh
the group instead of the snapshot then it will not truncate but it will delete
the rows.
Babu
----- Original Message -----
Sent: Wednesday, October 15, 2003 1:54
PM
Subject: complete refresh
hi
does complete refresh of mvs always do a truncate of the table and then
does an insert from the master site or is there a possibility when it deletes
the records in the table and does a insert of the records from master
site.
one more question is whether this functionality has changed from 7
to 8i/9i. some here in my team say in 7 version complete refresh used to
delete records and not truncate the snapshot.
thx
sai
|