Home » Server Options » Replication » ORA-00001: unique constraint (%s_PK) violated After replication configuration (Oracle 11g, Windows 2003)
ORA-00001: unique constraint (%s_PK) violated After replication configuration [message #490972] Fri, 28 January 2011 05:38 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Insufficient data to compute.

Regards
Michel
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 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi ,

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



pradeep

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 Go to previous messageGo to next message
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
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 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Try to re-run the mv refresh group
Previous Topic: Manual Replication
Next Topic: Golden Gate: Tuning
Goto Forum:
  


Current Time: Wed Jun 03 04:48:52 CDT 2020