RE: complete refresh

[Daniel Harron]

Title: Message

use: BEGIN    DBMS_SNAPSHOT.REFRESH (    list => 'tables',   method => 'C',   atomic_refresh => TRUE); END; /   -Daniel -- Daniel Harron Database Management IPsoft, Inc. [EMAIL PROTECTED] http://www.ip-soft.net/ Phone: 888.IPSOFT8 Fax: 801.681.7664   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oracle-L Sent: Wednesday, October 15, 2003 6:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: complete refresh 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 ----- From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L 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