Integrity Constraint violation while refreshing
Hi,
I am getting error Integrity Constraint violation when I try to refresh using Refresh group.
I have MVs that have parent/child relation ship. When I rfresh
it complains about a Parent key not found for a constraint. Is any one run into this problem?
How it can be resolved?
When I do DBL at Master site the follwing is the sequence it happens.
Insert into table A with PK value 1
Inserting into table B with Pk value 1
updating table A record that has PK value 1. ---it's complaining right here at Snapshot site when try to do reresh from refresh group.
The follwings are Oracle errors.
ORA-12008 error im MV refresh path
ORA-02291 integrity constraint (SYNAPSE.IMAGE_REMOTE_AE_FK) violated.
Parent key not found.
ORA-06512 at "SYS.DBMS_SNAPSHOT"
ORA-06512 at "SYS.DBMS_IREFRESH"
ORA-06512 at "SYS.DBMS_REFRESH"
Thanks.
Pravin