Trigger in Oracle 7.3

Hi there,

we have two database schema that cannot be merged but whose contents has to be in sync for some tables in each schema. Some tables refer records in tables that have to be in sync. Some references are from tables that are local to a schema. A record can only be deleted when no record in another table refers to the record

We have solved the situation in using database trigger that handle the data syncronisation. We classified the trigger to be able to create the triggers from seperate trigger tables we manage ourself. For our solution we have two opinions:

• Use one trigger for each table that handles insert, update and delete for the data sync and the referenc counting on refered data record.
• Use one trigger for each operation which means six trigger for each table.

Does anybody has experience which is more performant or if one of the solution may create problems. We have to hold 18 tables in sync.

Greetings

    Clemens Received on Fri May 14 1999 - 09:43:42 CDT