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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Improving performance on IMPORT utility ????????

Re: Improving performance on IMPORT utility ????????

From: Amit Aggarwal <amaggarwal_at_kendle.com>
Date: 1997/12/03
Message-ID: <3485E609.4C8C68C3@kendle.com>#1/1

Do not import indexes along with the data. This will save a lot of import time. You can create indexes after the import. If you are not sure what all indexes you will need to create, you can create an import file with indexfile option. This will create an SQL script to create indexes which you can run later after the data is imported.

Amit
Oracle DBA/Unix SA

A Ustby wrote:

> Anything I can do to improve IMPORT utility performance other than "buffers" ?
>
> I'm looking for anything, even UNIX tricks.....
>
> Thanks for any and all help...... Art
Received on Wed Dec 03 1997 - 00:00:00 CST

Original text of this message

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