Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMP/EXP parfile question

Re: IMP/EXP parfile question

From: <RogBaker_at_gmail.com>
Date: 1 Oct 2005 11:29:32 -0700
Message-ID: <1128191372.606334.295760@g43g2000cwa.googlegroups.com>


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 Received on Sat Oct 01 2005 - 13:29:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US