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: Diabling Snapshot Log per session

Re: Diabling Snapshot Log per session

From: Bruce Sargent <email_me_at_nospam>
Date: Mon, 25 Sep 2000 08:21:43 -0700
Message-ID: <39cf6d88$1@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 Mon Sep 25 2000 - 10:21:43 CDT

Original text of this message

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