Home » Server Options » Data Guard » constraint violation during SQL apply
constraint violation during SQL apply [message #145513] Thu, 03 November 2005 10:11 Go to next message
Roland17
Messages: 1
Registered: November 2005
Junior Member
Hello,

I set up a logical standby database with Oracle 10.2. It works, but sometimes I see messages in the DBA_LOGSTDBY_EVENTS view: "unique constraint violated...(during insert)" The rows in the concerning tables are identical at primary and standby site.
How can this happen??? If the insert fails at the primary it is rolled back and should not be transmitted to the standby...

Every hint is appreciated.

Regards,
Roland
Re: constraint violation during SQL apply [message #152448 is a reply to message #145513] Fri, 23 December 2005 04:11 Go to previous message
gscen_dba
Messages: 7
Registered: December 2005
Junior Member
Hello,

Did you have some tables with nologging options ?

Regards

Cyrille
Previous Topic: DataGuard License
Next Topic: Dataguard - How to Manually Apply Archive Logs
Goto Forum:
  


Current Time: Tue Dec 01 05:46:57 CST 2020