Re: IMP/EXP parfile question

On 1 Oct 2005 11:29:32 -0700, RogBaker_at_gmail.com wrote:

>Thanks for the quick reply Mark. Sorry to here you too are working on
>the weekend. Sorry, Version 8.1.7.4 (going to 9.X or 10 soon).
>Thats a great idea, rows=n. I will test after grabbing a bite to eat.
>
>Another export question you might be able to answer. I heard it's a
>good idea not to generate your indexes on the import, but to make a
>script and run them latter (after modifying with NOLOGGING). The way I
>heard to do this is with the INDEXFILE option on the import. However,
>after reading a .dmp file in my text editor, it looks like the commands
>for creating the indexes are already there, so why bother doing an
>import with INDEXFILE? Perhaps the INDEXFILE import strips out all the
>garbage, saving me editing time.
>Thanks,
>Roger

The indexfile= option *generates* a file with all create index statements. Note: this doesn't apply to indexes implementing Primary and Unique constraints.
An export should NEVER EVER be edited!!!

--
Sybrand Bakker, Senior Oracle DBA