-
HI,
Is it mandatory that the tables involved in replication should have one primary key..? Oracle Version is 8.1.6.
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|