Home » Server Options » Replication » Is Table Primary Key Essential for Oracle Replication
Is Table Primary Key Essential for Oracle Replication [message #75353] Wed, 02 April 2003 22:24 Go to next message
Satya Narayanan
Messages: 1
Registered: April 2003
Junior Member
Dear Sir,

Is primary key essential for all the tables to do the replication of a database

Thanks
Satya

Report message to a moderator

Re: Is Table Primary Key Essential for Oracle Replication [message #75369 is a reply to message #75353] Sat, 07 June 2003 02:09 Go to previous message
Paul van Velzen
Messages: 6
Registered: June 2003
Junior Member
No it is not. You can use rowid as well. However, we do not know how long Oracle will support snapshots with rowid. Primary key snapshot replication is more reliable.

Report message to a moderator

Previous Topic: Snapshot space problem
Next Topic: Snapshots without MLOG$ tables in remote database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 25 08:30:40 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.