Home » Server Options » Replication » ORA-00001: unique constraint violated (Oracle 9.2.0.6)
ORA-00001: unique constraint violated [message #338089] Sun, 03 August 2008 06:06 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

I got this error message in my replication environment.

ORA-12012: error on auto execute of job 2182370
ORA-12008: error in materialized view refresh path
ORA-00001: unique constraint (TE.S_TE_MTH_DBASE_SALES_INFO_A_U1) violated
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 189

Materialized view and Base table having only one unique index. There are no referable constraints in my base table. Because source table not refer any other tables.

Even; materialized view log created using rowid because there are no primary key constraints in my base table.

When I manually refresh materialized view I got the below error message

ORA-00001: unique constraint (TE.S_TE_MTH_DBASE_SALES_INFO_A_U1) violated


How it's possible? Because there is parent/child relationship in my source table and there is no way to enter duplicate records it's unique index.

Please let me know why occurs this error?

Babu

[Updated on: Sun, 03 August 2008 06:07]

Report message to a moderator

Re: ORA-00001: unique constraint violated [message #338093 is a reply to message #338089] Sun, 03 August 2008 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search the root of the error then you'll get the reason why it happens.

Regards
Michel
Re: ORA-00001: unique constraint violated [message #338704 is a reply to message #338093] Tue, 05 August 2008 13:51 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Mr.Michel,

Thanks for your support and sorry for my late response.

I am sure; there is no root errors. Can you explain me why its happen?

Thanks & Regards
Babu
Re: ORA-00001: unique constraint violated [message #338708 is a reply to message #338704] Tue, 05 August 2008 14:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there is a root error as you have duplicates they don't appear by miracle.
Search why you have duplicates.
Search what are the duplicates.

Regards
Michel
Re: ORA-00001: unique constraint violated [message #338709 is a reply to message #338708] Tue, 05 August 2008 14:26 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>Search why you have duplicates.
>>Search what are the duplicates.


Yes; you’re correct Mr.Michel; once occur error from my database; immediately i checked duplicate records in my database

There is no duplicate records; Even my table/materialized view having unique index so; there is no way to enter duplicate records.

I'm correct? Advice me

Thanks
Babu
Re: ORA-00001: unique constraint violated [message #338711 is a reply to message #338709] Tue, 05 August 2008 15:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't enter duplicates but you can have duplicates during replication if the values already exist in mv.
Check.

Regards
Michel
Re: ORA-00001: unique constraint violated [message #338715 is a reply to message #338711] Tue, 05 August 2008 15:43 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Materialized view also having unique index.

Babu

Re: ORA-00001: unique constraint violated [message #338788 is a reply to message #338715] Tue, 05 August 2008 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And so the error you got.
The error comes that when you refresh you try to violate this constraint, search why, which rows try to violate this constraint.

Regards
Michel
Re: ORA-00001: unique constraint violated [message #339049 is a reply to message #338788] Wed, 06 August 2008 12:01 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Ok Mr.Michel.

Thanks for your support.

Once again i will cross check.

Thanks & Regards
Babu
Previous Topic: Status of Refresh group to Broken
Next Topic: Problem in refreshing MV
Goto Forum:
  


Current Time: Thu Mar 28 10:39:58 CDT 2024