Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_reputil.replication_off fails
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