Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: imp table data, but not PK indexes?
> as PK comes under 'constraints' you might also have to do constraints=N
> also...
>
> On Sat, 19 Jul 2003 07:04:23 -0800, "Ganesh Raja" <gans_r_at_rediffmail.com>
> wrote :
>
> > Use the Indexes = N Option and Create the Index Seperatley ..
> >
Yes, but IIRC CONSTRAINTS=Y is an exp parameter, not imp?
Best way to handle these things is to export twice. Once with all the "bells and whistles" turned on but ROWS=N (this gives you a small export file with all the schema logic added and takes no time at all). The next one is with CONSTRAINTS=N, ROWS=Y, INDEXES=N, DIRECT=Y. This one is used for bulk data load.
With these two exports, one can do just about any manipulation needed.
Cheers
Nuno Souto
Received on Sat Jul 19 2003 - 18:52:38 CDT
![]() |
![]() |