Members   Search   Help    Register    Login   Home
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
holdingbe
Messages: 137
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.
Report message to a moderator
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: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 17:52:45 CST 2009

Total time taken to generate the page: 0.28043 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.