Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    46

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    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.

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •