Help - Search - Members - Calendar
Full Version: Row Violations due to Referential Integrity Constraint in Oracle
Oracle DBA Forums > Oracle > Oracle Forum
sunil joshi
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.
burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.