OraFAQ Forum: Replication » ORA-00001: unique constraint (%s_PK) violated After replication configuration

Home » Server Options » Replication » ORA-00001: unique constraint (%s_PK) violated After replication configuration (Oracle 11g, Windows 2003)

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

ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #490972]

Fri, 28 January 2011 05:38

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

I Have configured the replication between two database's at table level. After few miniuts of successful configuration of replication between two db's at table level, I am getting the ORA-00001: unique constraint (%s_PK) violated error in dba_apply_error.

I checked constraint name,type and status on table replicated is same on both source and destination db.

Can some one tell me how can i resolve this issue.

Thanks

Pradeep

Report message to a moderator

Re: ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #490985 is a reply to message #490972]

Fri, 28 January 2011 06:30

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Insufficient data to compute.

Regards
Michel

Report message to a moderator

Re: ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #490993 is a reply to message #490972]

Fri, 28 January 2011 06:54

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi ,

Kindly tell me what else I can provide related to this issue.

pradeep

Report message to a moderator

Re: ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #490995 is a reply to message #490993]

Fri, 28 January 2011 06:56

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

Now I am getting this error in dba_apply_error

ORA-26786: A row with key ("ANI") = (7569460612) exists but has conflicting colu
mn(s) "AMOUNT", "BILLING_DATE", "CHARGING_DATE", "HIT_DATE_TIME", "NEXT_BILLING_
DATE", "SAMRESPONSE", "STATUS" in table RFC_DB.TBL_VOICECHAT
ORA-01403: no data found

regards
Pradeep

Report message to a moderator

Re: ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #492373 is a reply to message #490995]

Sun, 30 January 2011 09:23

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Try to re-run the mv refresh group

Report message to a moderator

Previous Topic:	Manual Replication
Next Topic:	Golden Gate: Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:33:12 CST 2025