| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Snapshot based Replication : Master table truncate
Hi,
I think that when you are truncate the table you need to do a complete refresh of the snapshot.
Danut,
Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca
> 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).
Received on Tue Jul 18 2000 - 17:05:48 CDT
 |
 |