DBMS_ALERT or DBMS_PIPE???

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