Take a look in the docs at the syntax: truncate table <tablename> preserve/purge snapshot log;
"The SNAPSHOT LOG clause lets you specify whether a snapshot log defined on the table is to be preserved or purged when the table is truncated. This clause allows snapshot master tables to be reorganized through export/import without affecting the ability of primary-key snapshots defined on the master to be fast refreshed. To support continued fast refresh of primary-key snapshots, the snapshot log must record primary-key information. PRESERVE Specify PRESERVE if any snapshot log should be preserved when the master table is truncated. This is the default. <<<<<<< this is why you are not seeing the truncate being replicated.... PURGE Specify PURGE if any snapshot log should be purged when the master table is truncated" -Joe --- Vladimir Barac <[EMAIL PROTECTED]> wrote: > Hi! > > I have noticed something... > > Deletes are propagating from master site to the snapshots. > Everything works like charm, as it is supposed. > > But... truncate of master table IS NOT seen in snapshot table. I > don't really expect snapshot to be truncated, of course, but I > expect it to be empty (trunace is essentially delete). > > So, is this bug or feature? What is logic behind it, if it is > feature? > > > __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
