Home » RDBMS Server » Server Utilities » Imporve the import performance (Oracle 10.2.0.4 ,linux)
Imporve the import performance [message #428049] Tue, 27 October 2009 00:36 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I want ignore the all index during the import process.After the loading data into tables. we have created index in the schema because of the improve the import performance.

I don't know how to implementation this process but i know this process is implementation by indexfile option in import utlity?


Please give me the implementation notes?


Thanks,
Mmichael Holding.
Re: Imporve the import performance [message #428056 is a reply to message #428049] Tue, 27 October 2009 00:51 Go to previous message
Michel Cadot
Messages: 63807
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i know this process is implementation by indexfile option in import utlity?

Read in the documentation the purpose of indexfile parameter.
It will help you to get the list and create statement for your indexes.
But you need to import with INDEXES=N parameter.
So there are several steps.

Regards
Michel

[Updated on: Tue, 27 October 2009 00:53]

Report message to a moderator

Previous Topic: On Import PLS-00302: component 'SET_NO_OUTLINES' must be declared
Next Topic: ctl file loading
Goto Forum:
  


Current Time: Wed Sep 28 12:36:58 CDT 2016

Total time taken to generate the page: 0.09544 seconds