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.

Hi Sunil,

>> Referential Integrity is very important in Oracle database.

False. Many world-class applications do their own internal referiemntial integrity withut using Oracle's RI.

*******************************************************
>> Only application code was leveraged over the past 1 year to manage this logic.

Huh? I had databases with RI back in 1983, before Oracle!

*********************************************
>> flag all row level violations with referential integrity

Yes. There is an "exceptions" clause on the add constraint syntax . .

http://www.dba-oracle.com/t_see_referentia..._violations.htm