So I have an Oracle database with a parent table and three child tables
and various attributes from them that I want to sync.
I'm not keen on modifying the underlying tables. At this point I want
to use an indirect approach and am primarily concerned with the
Can I create a view of each table, put triggers on the views, and have
them update the event log? That's what would be ideal, but I don't see
how it would work. I don't think the trigger would ever fire.
My concern is the required constraints to make the parent child
relationship work. I really don't want to constrain the underlying
tables as this could have adverse effects on the application. There are
currently no constraints...
Thanks in Advance!!