Ask the Expert

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 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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: