DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: replication

  1. #1
    Join Date
    Jul 2001
    Posts
    40

    Question

    HI,

    Is it mandatory that the tables involved in replication should have one primary key..? Oracle Version is 8.1.6.



  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    I am currently looking into this.

    I believe that each table must have a unique identifier or a composite of columns which would make each record unique.

    I don't think that you need to set up a PK constraint on each table.

    Someone, please correct me if I am wrong.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    May 2001
    Posts
    736
    Yes it is strongly recommended by Oracle to have Primary key on the tables which are involved in replication.Especially those involved in Fast refresh. As mentioned by sureshy that u will miss uniqueness among the records replicated environment. Even though u created a replication with objects without a primary key u will face lot of problems in resolving some of the key issues like duplicate values eminating from different sites.
    Search on Metalink u will find lot of issues evolving key concepts,u can imagine the impact on the replicated objects which doesnot have the keys.
    regards
    akhadar

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If you are setting up Master-Master Replication, then PK is a must on the tables.

    Otherwise ( Snapshot Replication), you do not need PK on the table.


Posting Permissions

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


Click Here to Expand Forum to Full Width