Updating Foreign Keys

[Pinki Meggi]

Hi,

I need to update a PRIMARY KEY but there is FOREIGN KEYS in other tables. I dont know how to do this.

Can i disable the FOREIGN KEYS Constraints ? Or there are another solution?

Please need help.


Thanks in advance

Best Regards

Pinki

[Peter Godron]

Pinki,
Primary keys should not be updated !

The totally correct way would be to remove the record with the primary key and the connected records. Then re-create the record with new key and the connected records.

The not so correct way is to temporarily remove the foreign key constraint, change the record and then re-enable constraint.

Please check your database referential consistency afterwards !

[Oviwan]

Hey

Check this question:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:914629004506

perhaps you find other tipps at http://asktom.oracle.com

Regards