I'm interested if it is possible to replicate two tables connected with foreign key contraint. What structure should be used ? Can they be updateable in both sides of replication enviroment ?
I use Oracle 8i.
Thanks in advance
Yes they can be updateable ... Either thru snapshot or multimaster replication.
You MUST rebuild the foreign key to be DEFERRABLE. The constraint rules will not be checked until the entire trx has completed.
If you are using snapshot replication, ensure that the children and parent tables are in the same refresh group.