Re: Snapshot based Replication : Master table truncate

Danut,

You are correct, truncating the master table requires doing a complete referesh. There was a documentation error, can't remember which release, that said that the snapshot site would detect that the master table had been truncated and automatically do a complete refresh, but that is not correct. You must manually do a complete refresh on the snapshot or drop and recreate the snapshot.

HTH,

• Anita
  • Danut Bancea <danut_at_telepages.ca> wrote:
    > Hi,
    >
    > I think that when you are truncate the table you
    > need to do a complete
    > refresh of the snapshot.
    >
    > Danut,
    >
    >
    

    ---

    
    > Danut Bancea
    > Senior Oracle DBA
    >
    > Tele-Pages Inc.
    > Phone : (416) 296-9011 Ext. 2271
    > Fax : (905) 477-7062
    > E-mail : danut_at_telepages.ca
    >
    >
    

    ---

    
    > ----- Original Message -----
    > To: Multiple recipients of list ORACLE-L
    > <ORACLE-L_at_fatcity.com>
    > Sent: Tuesday, July 18, 2000 1:20 PM
    >
    >
    > > Hi List,
    > >
    > > I have a query related to Oracle805 (Snapshot
    > based replication).
    > > I have a table in the master database which is
    > replicated in another
    > > database using Primary Key based snapshots. We are
    > using
    > > fast refresh for this, every one hour.
    > > The problem which I am facing presently is that
    > when we truncate
    > > the master table, the replicated table becomes off
    > the sync with
    > > the master table. Any ideas ????
    > >
    > > TIA,
    > > Mahip
    > > --
    > > Author:
    > > INET: mahib.narayan_at_bt.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).
    > >
    >
    > --
    > Author: Danut Bancea
    > INET: danut_at_telepages.ca
    >
    > 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).
    

    ---