Database Administration (MOSC)

MOSC Banner

wrong reference when inserting

edited Nov 6, 2012 8:07PM in Database Administration (MOSC) 2 commentsAnswered
hello all

we are experiencing a weird case:

there are two schemas: A and B

both contains same pair of parent-child tables:  Parent and Child, and the fk constraint have the same name for both schemas (A.fk and B.fk)

Sometimes when user A tries  to insert into Child table and error rises :

ORA-02291: integrity constraint

and the error refers to B.fk whern the correct fk is A.fk

Does any one have had this kind of problem ??

tks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center