Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Improving performance on IMPORT utility ????????
In article <3485E609.4C8C68C3_at_kendle.com>, Amit Aggarwal
<amaggarwal_at_kendle.com> writes
>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
>
>
>
I thought that indexes were always created at the end of the import,
that's were they appear in the import file.
Did you mean remove any existing indexes in the current indexes before importing?
Andy
-- Andy Hardy Senior IT Systems Engineer Cegelec AEG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions are mine and do not necessarily reflect those of Cegelec AEGReceived on Thu Dec 04 1997 - 00:00:00 CST
![]() |
![]() |