Re: imp table data, but not PK indexes?

From: Nuno Souto <nsouto_at_optusnet.com.au>
Date: Sun, 20 Jul 2003 09:52:38 +1000
Message-Id: <25962.338578@fatcity.com>

Original Message ----- From: "rahul" <rahul_at_infotech.co.id> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, July 20, 2003 2:04 AM Subject: 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