Oracle-L: Re: Replication - truncate not propagating

From: Alessandro Guimaraes <alessandro_at_applysolutions.com.br>
Date: Mon, 29 Jul 2002 05:43:27 -0800
Message-ID: <F001.004A4767.20020729054327@fatcity.com>

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 Guimaraes

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?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alessandro Guimaraes
INET: alessandro_at_applysolutions.com.br

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: ListGuru_at_fatcity.com (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). Received on Mon Jul 29 2002 - 08:43:27 CDT