Q

Import of dump file took 20 hours

I tried to import a database dump onto my Oracle server using the imp command. The size of the file is 7GB and it took around 20 hours to complete.

I tried to import a database dump onto my Oracle server using the imp command. The size of the dump file (.dmp) is 7GB and it took me around 20 hours for the import to be completed. This was the import command used:
imp mmm_prod/mmm_prod@bo6 file=\ranjithnPRODaris_prod.exp.dmp
log=\ranjithnPRODaris_prod.imp.log grants=n commit=y ignore=y full=y
Is it fine for the import to take 20 hours? Kindly advise me on the best way to use the imp command to import a dump onto an Oracle 9i server. Thanks.
The only suggestion that might speed things up a bit is to specify a larger buffer size with the BUFFER parameter, to reduce the number of commits. Try BUFFER=10485760 or even 104857600.
This was first published in January 2007

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close