RI to be enforced in tables containing data

[shsandeep]

I created all the tables in my database (about 100 of them) a while ago
without enforcing the RI constraints.
Now, most of them are loaded with data and I need to execute those RI DDLs
on the entire database.
Is this something completely wrong or ok to go ahead with? I require your
suggestions here.

Thanks.

Cheers,
San.

[Shashi Mannepalli]

You can create the RI at what/when ever you want to.
But if the data is violating those RI rules then you will not be able
to create RI for them.
Then u need to figure out what are the RI violated ROWS and what to do
with them...ETC

cheers...
Shashi Mannepalli

shsandeep wrote:

I created all the tables in my database (about 100 of them) a while ago
without enforcing the RI constraints.
Now, most of them are loaded with data and I need to execute those RI DDLs
on the entire database.
Is this something completely wrong or ok to go ahead with? I require your
suggestions here.

Thanks.

Cheers,
San.

[mirof007]

Shashi Mannepalli wrote:

You can create the RI at what/when ever you want to.
But if the data is violating those RI rules then you will not be able
to create RI for them.
Then u need to figure out what are the RI violated ROWS and what to do
with them...ETC

cheers...
Shashi Mannepalli

Actually, in a case where you expect some of your data to viloate the
constraint, you can simply put the table into the set intergity pending
state (using the SET INTEGRITY OFF statement) prior to enabling the
enforcement of the constraint, and then subsequenlty run SET INTEGRITY
IMMEDIATE CHECKED with an exception table, that will delete all
violating rows for you and move them to the exception table.This works
for RI constraints, as well as check constraints, BTW.

Regards,
Miro