Triggers on Views -
06-16-2004
, 02:30 PM
Hi Guys :
Scenario :
Database A is on one server (tables A, B, C)
Database B is on another server ( tables X Y Z)
I would like to establish a link between these databases.
When a new row is inserted in table A of Database A I want to insert
some columns of tables A to table X on database B .
When a row is updated in table Y of database B i would like to update
table B on database A.
I was wondering
a) Whats the best feasible approach to solve this scenario
b) If i create DB Links and create views can I write triggers on
Views ?
c) What are the pros and cons of different approaches.
All your help would be greatly appreciated.
Thank you |