I am moving a database from 8i to 9i.

I have a full DB export from 8i.

I created the 9i instance.
I imported the full DB export with full=Y, rows=N, constraints=Y, indexes=y,
grants=Y; this created all the objects of the primary schema but about 100
constraints did not come in saying:

IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE
"IBKAUL" ADD CONSTRAINT "SYS_C004546" CHECK (" ""PRIV_ID" IS NOT NULL" " )
ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

All the constraints that did not come in have names like "SYS_*"

Also, can anyone point me to a script that will generate the creation script
for all the constraints for a specific schema.


Best Regards,
R



Oracle LazyDBA home page