Hi all,
is there an easy way to recreate the constraints for a schema? I did an export from my old SCSI drives, replaced newer, larger drives and reinstalled all the software, then did an import (since Windows was hosed and I couldn't use the tape backup software or even reinstall anything).
However, after doing the import, none of the constraints existed. How can I extract just the constraint information and re-create it on the new installation (I know I have to go through the drive swapping routine again).
Also, a related question about the dba_col_comments and dba_tab_comments. I forgot to export those views. Can I simply export the underlying base tables and re-import those, or am I stuck having to recreate all the comments? Can I write a SQL script (or does anybody have one handy), to extract the comment data for
my schema so I can recreate them on the new drives/installation?
TIA,
-----------------------------------------------------------------------------
Bill Ferguson
U.S. Geological Survey - Minerals Information Team
PO Box 25046, MS-750
Denver Federal Center
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208
~ Think on a grand scale, start to implement on a small scale ~