Referential Integrity is very important in Oracle database. Consider a scenario where constraints were applied to a database
but never enforced on. Only application code was leveraged over the past 1 year to manage this logic.
Over the course of the year there might have been lot of Row Violations which might have led to Data Inconsistency Issues.
Do we have a Script, Tools in Oracle which flag all row level violations with referential integrity now being turned on.