----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 20, 2003 2:04 AM
> 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" <[EMAIL PROTECTED]> > 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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).