By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.