Re: Help with a trigger

From: Eduardo Pimenta <epimenta_at_my-dejanews.com>
Date: 1999/03/17
Message-ID: <7co8n0$ant$1@nnrp1.dejanews.com>#1/1

Seems that you're trying to do a replication schema...

It will probably work better if you do it via snapshots instead of triggers. Search for "snapshots" and "replication" in the Oracle documentation, that will be a good starting point.

Hoping to have been of some help,

Eduardo Pimenta.

In article <Pine.GSO.3.96.990316160015.27096B-100000_at_jupiter.icpb.ca>, Praim Sankar <psankar_at_icpb.ca> wrote:
>
> hello world!
>
> I need to create a trigge that would fire in the following scenario:
>
> I have two Oracle databases on the same NT server. I need a trigger that
> will fire whenever there is an update, insert or delete in the first
> database. It would then grab the current data, connect to the 2nd database
> and update it.
>
> Any help would be greatly appreciated.
>
> Thanks
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 00:00:00 CST