faster import of db objects

[iris]

Hi, how can we speed up the importing object to database using imp utility.


thanks,

[hany]

Have a look at Buffer parameter here

You may also consider splitting up the job into pieces so do multiple imports in parallel instead of one import sequentially.

[vnktummala]

imp will not support parallel parameter. You need to write a explicit program to do imports in parallel sessions if you have multiple dump files.

You can create the indexfile from the dump file and import with out indexes then create the indexes manually.

by the way, what is the Oracle version?

Thanks,

[hany]

imp will not support parallel parameter. You need to write a explicit program to do imports in parallel sessions if you have multiple dump files.

Thanks,

I wasn't actually refering to a "parallel" parameter. As mentioned split the import job into more than one job, i.e more than one import session, a session importing some of the tables, another importing the others and so on.

[vnktummala]

I understand what you mean to say Hany. I just want to make the poster more clear about doing imp in multiple sessions.

Thanks,

[naman20k]

you can create an indexfile so that you can create indexes AFTER you have imported data. Do this by setting INDEXFILE to a filename and then import. No data will be imported but a file containing index definitions will be created. You must edit this file afterwards and supply the passwords for the schemas on all CONNECT statements

[naman20k]

or u can increase the db_cache_size and set the log_buffer to a high value

[mahajanakhil198]

or u can increase the db_cache_size and set the log_buffer to a high value

How will that increase the import speed?