Please help: missing foreign keys

It looked like my new release of database was missing lots of the foreign keys, instead of checking each object in data model, have any ways I can have a script to list all of the foreign key suppose to be created and generate a create foreign key script for those missing one.

Thanks

Blu

Easy way i would do it by downloading ERwin freeware.

Do a reverse enineering using ER win ,It will be helpful

Manoj

Query DBA_CONSTRAINTS where constraint_type='R' additionally you can query DBA_CONS_COLUMNS to get the required info.