Re: Replication - truncate not propagating

From: Joe Raube <jraube_at_yahoo.com>
Date: Mon, 29 Jul 2002 06:13:29 -0800
Message-ID: <F001.004A4867.20020729061329@fatcity.com>

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 <vladob_at_aster.si> 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: jraube_at_yahoo.com

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 - 09:13:29 CDT