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.
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.
Click Here to Expand Forum to Full Width