If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Oracle8i replication+foreign key

Hi,
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
Szalas

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.