Dear all,

I have a table that recently I found it has orphan records with the foreign key is enable and validate. I am not sure how could that happen? I tried to delete and recreate the foreign key, and I was able to do so, I also tried to validate the constraint and was able to do that too. I am not sure if there is anything that would allow the foreign key to be ignored?

Any help is appreciate.


Thanks,
Unna