Re: Help with a trigger

From: Guus van de Sande <gs.dyntas_at_wxs.nl>
Date: Tue, 16 Mar 1999 23:30:57 +0100
Message-ID: <7cmm2g$9pc$1@reader1.wxs.nl>

You should not use a trigger mechanism for that purpose. Oracle added the Replication Option for that matter. Triggering is usefull for specific action at table-level. If that is what you want, then create a database-link and then you can use the trigger for updating that single table in the remote database.

regards,
Guus van de Sande
DYNTAS Consultancy BV
The Netherlands

Praim Sankar heeft geschreven in bericht ...
>
>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
>
Received on Tue Mar 16 1999 - 16:30:57 CST