Home » Server Options » Replication » updating primary key in replication environment
updating primary key in replication environment [message #75498] Fri, 30 April 2004 06:47 Go to next message
Govind Thangavelu
Messages: 2
Registered: April 2004
Junior Member
Hello,

I have a oracle 9i asynchronous replication environment with single master. Is is good idea to update primary keys ?. Please let me know. If it is not a good idea, then please explain why ?.

 

Govind

Report message to a moderator

Re: updating primary key in replication environment [message #75508 is a reply to message #75498] Sun, 20 June 2004 08:22 Go to previous message
Justin Cave
Messages: 8
Registered: December 2003
Junior Member
As a schema design issue, it is never a good idea to update primary keys. If you are considering a column for a primary key, and you can imagine that the column will be updated, then that column is not a good candidate for a primary key. If there are no immutable columns in your table, you would generally want to create a synthetic primary key populated by a sequence.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

Report message to a moderator

Previous Topic: Replication
Next Topic: Oracle Replication - Stopping Deletes ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 11:52:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.