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