Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Improving performance on IMPORT utility ????????
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
![]() |
![]() |