| Imporve the import performance [message #428049] |
Tue, 27 October 2009 00:36  |
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  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
