Orphanage Chid Record without Master
Hi Guys,
We have a child record without the master record in the database. We know that as long as foreign key constraint enabled this is not possible so we query the table and found that foreign key constraint is enabled and validated, to make sure oracle that Oracle constraint validation is working properly in 11gr2 on linux 64 bit database we disabled the FK constraint and tired to enable it again while orphan record exists it has failed which is fine by us and we can confirm that the FK constraint validation is working now.
However we are unable to find the root cause; how our master record got deleted while child record existed with FK constraint enabled. Can anyone list all the possbile scenarios?
We have a child record without the master record in the database. We know that as long as foreign key constraint enabled this is not possible so we query the table and found that foreign key constraint is enabled and validated, to make sure oracle that Oracle constraint validation is working properly in 11gr2 on linux 64 bit database we disabled the FK constraint and tired to enable it again while orphan record exists it has failed which is fine by us and we can confirm that the FK constraint validation is working now.
However we are unable to find the root cause; how our master record got deleted while child record existed with FK constraint enabled. Can anyone list all the possbile scenarios?
0