Re: Diabling Snapshot Log per session

I found the dbms_reputil and dbms_snapshot packages. They allow you to disable advanced replication, but they do not seem to affect the snapshot log.

"Bruce Sargent" <email_me_at_nospam> wrote in message news:39cf6d88$1_at_news.microsoft.com...
> Disabling the trigger will cause other session changes to be lost, I only
> want the changes applied by the current session not to replicate. Plus
 with
> Oracle 8 they use 'internal triggers' that do not seem accessable. My
> program is updating the tables on both sides so I'm not worried about
> getting out of sync, but I don't want my changes getting replicated
 because
> the change will already be applied to both sides.
>
> "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message
> news:sssa7blq0nmo61_at_corp.supernews.com...
> > Snapshot logs are updated via a trigger. If you have permisions to
 disable
> > the trigger, that would do the trick. However, if the goal is for the
> > snapshots to refresh fast, they will fail to do so as the snapshot logs
 will
> > be out of sync with the table. To fix that problem you *may* have to do
 a
> > full snapshot refresh which will of course, bring over the changes.
> >
> > In short, I began this post thinking yes, that should be possible, and I
> > have now talked myself out of that idea :-)
> >
> > --
> > Dave A
> >
> >
> > "Bruce Sargent" <email_me_at_nospam> wrote in message
> > news:39cd9769$1_at_news.microsoft.com...
> > > Is there a way to disable snapshot logging for a given session? I want
 to
> > > write a program that will apply changes to the base table without the
> > > changes being replicated.
> > >
> > >
> >
> >
>
>
Received on Wed Sep 27 2000 - 15:50:13 CDT