Home » Server Options » Replication » Replication -Primary key
Replication -Primary key [message #75604] Sun, 16 January 2005 19:33 Go to next message
archa
Messages: 4
Registered: January 2005
Junior Member
I am not able to repliacte the tables which do not have primary keys.Plz help me regarding this.I have selected rowid option but still i am getting primary key error.
Re: Replication -Primary key [message #75606 is a reply to message #75604] Thu, 20 January 2005 23:49 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
More info please: post your SQL and error message.

Best regards.

Frank
Re: Replication -Primary key [message #75613 is a reply to message #75604] Fri, 04 February 2005 22:15 Go to previous messageGo to next message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
Try replicating using Rowid
Re: Replication -Primary key [message #112833 is a reply to message #75604] Tue, 29 March 2005 10:40 Go to previous message
tarun123v
Messages: 9
Registered: March 2005
Location: Hyderabad(India)
Junior Member

Try Replicating using rowid: as we know whenever a table is created
Oracle automatically creates rowid(by default) rowid of each table
is unique So you can use rowid to replicate the table or tables

[Updated on: Tue, 29 March 2005 10:41]

Report message to a moderator

Previous Topic: Replication between 2 database with 1 source table to 2 or more target tables
Next Topic: Database Link Issue
Goto Forum:
  


Current Time: Thu Mar 28 13:48:27 CDT 2024