Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import indexfile=blah - What about constraints ?

Re: Import indexfile=blah - What about constraints ?

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Sun, 08 Aug 1999 20:31:16 -0400
Message-ID: <37AE2154.DB7CD537@bigfoot.com>


Yes..this annoys me also. You need to run a separate script to get all the constraints..

Neil Cudd wrote:

> 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 Sun Aug 08 1999 - 19:31:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US