ORA-28117: integrity constraint violated - parent record not
found



ORA-28117: integrity constraint violated - parent record not found..

Answer / guest

Cause: try to update/insert a child record with new foreign
key values, but the corresponding parent row is not visible
because of fine-grained security in the parent.

Action: make sure that the updated foreign key values must
also visible in the parent

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-01175: Password unchanged

1 Answers  


ORA-13630: The task string contains execution results and cannot be executed.

1 Answers  


ORA-07263: sptpa: kill error.

1 Answers  


ORA-01572: rollback segment 'string' cannot be brought online, string extents exceeded

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  






DRG-10819: could not open contains cursor

1 Answers  


ORA-16036: invalid MANAGED recovery CANCEL option

1 Answers  


QSM-00508: statistics missing on tables/columns

1 Answers  


ORA-09828: SCLFR: atomic latch return error.

1 Answers  


ORA-07267: spwat: invalid process number.

1 Answers  


ORA-32341: The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"

1 Answers  


LFI-00149: Error on destroying hash table in function string

1 Answers  


Categories