Import indexfile=blah - What about constraints ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Thu, 5 Aug 1999 10:40:26 +0100
Message-ID: <933846153.8689.0.nnrp-06.c2de6f3d@news.demon.co.uk>

I'm trying to export a schema from my prod'n db and import into my test server after modifying the initial extent allocation (short on disk space !).

I did an import with indexfile='filename' to get the table and index DDL and modified all the initial allocations - no problemo. But I've just noticed that no constraint ddl was generated with the indexfile='filename'. Unfortunately all my primary keys were created as constraints !

Any ideas greatly appreciated.

Regards,

neil. Received on Thu Aug 05 1999 - 04:40:26 CDT