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
Messages: 1
Registered: November 2005
Junior Member

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.

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

Did you have some tables with nologging options ?


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

Current Time: Mon May 29 04:16:56 CDT 2023