I need your help on some replication matter I guess. I'm actually not a dba, but I need to do some work on my db: I have a remote db, with table1, table2 and a local db with table3 and table4 in local db. table1 and table3 have the same column names and number of columns, but table4 has an id column in addition to table 2 columns.
my objective is to keep data synchronized in both dbs which means have same data on table 1 and table 3, and same common columns data on table 2 and 4.
what I did so far is to create a dblink between local and remote db and merge scripts, but I need to do it manually everytime there are changes on remote db, is there any better way, I thought of a trigger but don't know where to create it and how it will detect changes on remote db to replicate them in local. I appreciate any help or advice even the RTFM ones :D