ORA-02291 integrity constraint violated -- seems to cross schemas when it should not
Hello,
A couple of questions regarding ORA-02291 errors that are starting to pop up in our system.
We have an instance that has multiple copies of the same application setup under different schema names. Lately we have been getting ora-02991 errors from one schema that reference the correct parent table name but in a different schema.
eg in schema1 an insert into table1 returns Integrity Constraint (schema2.constraintFX) violated.
Now both schemas have the same constraint on the same columns and the definition of the constraint is:
A couple of questions regarding ORA-02291 errors that are starting to pop up in our system.
We have an instance that has multiple copies of the same application setup under different schema names. Lately we have been getting ora-02991 errors from one schema that reference the correct parent table name but in a different schema.
eg in schema1 an insert into table1 returns Integrity Constraint (schema2.constraintFX) violated.
Now both schemas have the same constraint on the same columns and the definition of the constraint is:
ALTER TABLE "schema1"."table1" ADD CONSTRAINT "constraintFK" FOREIGN KEY ("child_column")
REFERENCES "schema1"."parent_table" ("parent_column") ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED ENABLE;
0