Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_reputil.replication_off fails

Re: dbms_reputil.replication_off fails

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 26 Jul 1999 09:11:38 -0700
Message-ID: <379C88BA.A132DEF8@us.oracle.com>


Kevin

Are you running the replication_off in the same session as the deletes?

Pete

Kevin J Barnes wrote:

> I am using O8 1.5 workgroup server (not ee) and have set up snapshot
> logs on one database with fast refresh snapshots on another.
>
> Everything works fine, updates/changes/deletes are propageted when I
> run the dbms_repcat.refresh procedure.
>
> The problem comes in when I want to delete rows from the primary
> database and NOT propagate the deletes. Running
> dbms_repcat.replication_off does NOT stop the replication process and
> the mlog$ file is filled up with the deletions.
>
> Is this a bug in 8.1.5 or does replication_off not work with basic
> replication and I need to go install the advanced replication option?
>
> Any insight would be greatly appreciated.
>
> TIA
>
> Kevin

--
Regards

Pete


Received on Mon Jul 26 1999 - 11:11:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US