Re: Replication - truncate not propagating

[Alessandro Guimaraes]

Vladimir,   When a table is truncated, its snapshot log is also truncated. If the PURGE SNAPSHOT LOG option is specified, the snapshot log is purged along with the master table. If you specify the PRESERVE SNAPSHOT LOG option or no option, the information in the master table's snapshot log is preserved, but current ROWID snapshots can use the log for a fast refresh only after a complete refresh has been performed. This is the default.   Alessandro Guimarães ----- Original Message ----- From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Monday, July 29, 2002 5:23 AM Subject: Replication - truncate not propagating 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?