Re: DBMS_ALERT or DBMS

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 29 Mar 2002 20:39:11 +0000
Message-ID: <3CA4D0EF.D70F48A2@exesolutions.com>

One way would be to use an after insert or update or delete trigger firing off an email using UTL_SMTP. That's if you just need to be notified. If you want to maintenance included you are looking at replication.

Daniel Morgan

markag wrote:

> Hi all,
>
> Here is my situation:
>
> I have 2 databases, Development and Live. There are a group of base
> tables on the both databases that need to have the same records in them.
> Essentially, they are 'support' tables for the application. I need a way
> to be notified when a developer changes a record on the development
> database (unfortunately, they need this ability for efficient
> development) in any of these tables so that when I do an update I add
> the changed row of data to the live database or at least log it
> somewhere.
>
> What is the best way to do this?
>
> --
> Posted via dBforums
> http://dbforums.com
Received on Fri Mar 29 2002 - 14:39:11 CST

Re: DBMS_ALERT or DBMS_PIPE???