The transaction that does the delete should start with:
dbms_reputil.replication_off;
do the delete actions;
dbms_reputil.replication_on;
This will do the deletes but not replicate them.
HTH
Ted
<arlenk_at_my-deja.com> wrote in message news:8njdqn$ovc$1_at_nnrp1.deja.com...
> Hey All,
>
> At the company I work for we have a large Oracle db that is pretty much
> connected to and runs a production line. For obvious reasons, we don't
> want to allow access to this DB to just anyone.
>
> We would like to replicate some of the data on other oracle DBs
> and "basic replication" with read-only snapshots seems like an ideal
> solution. The only problem is that our main db only keeps 3 months of
> production line data, but we want the replicated source to contain all
> previous data.
>
> So, is there any way for the snapshot to capture all changes to the
> main DB except for the deletes?
> Or could we just turn replication off for the "archiving" process that
> runs every few months and truncates the production line data?
>
> Thanks for any help.
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Aug 19 2000 - 05:33:15 CDT