OraFAQ Forum: Replication » Replication -Primary key

Home » Server Options » Replication » Replication -Primary key

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replication -Primary key [message #75604]

Sun, 16 January 2005 19:33

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.

Report message to a moderator

Re: Replication -Primary key [message #75606 is a reply to message #75604]

Thu, 20 January 2005 23:49

Frank Naude
Messages: 4564
Registered: April 1998

Senior Member

More info please: post your SQL and error message.

Best regards.

Frank

Report message to a moderator

Re: Replication -Primary key [message #75613 is a reply to message #75604]

Fri, 04 February 2005 22:15

Sreedhar Reddy
Messages: 55
Registered: January 2002

Member

Try replicating using Rowid

Report message to a moderator

Re: Replication -Primary key [message #112833 is a reply to message #75604]

Tue, 29 March 2005 10:40

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 02 13:23:32 CDT 2020