Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import indexfile=blah - What about constraints ?
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