Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integrity Constraint violation while refreshing

49802Apr 1 2002
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





Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2002
Added on Apr 1 2002
4 comments
606 views