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
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.
Previous Topic: Snapshot space problem
Next Topic: Snapshots without MLOG$ tables in remote database
Goto Forum:
  


Current Time: Thu Mar 28 09:16:19 CDT 2024