Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Diabling Snapshot Log per session
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 Mon Sep 25 2000 - 10:21:43 CDT
![]() |
![]() |