Home » RDBMS Server » Server Utilities » Import -Export (Oracle10g)
Import -Export [message #382404] Thu, 22 January 2009 03:10 Go to next message
Messages: 82
Registered: January 2009
Location: mumbai

Hi Experts,
Please tell me how can i reduce the time for Export -Import.
When I perform Export from my current DB it took around 30-45 min,
For Import it took around 2-3 hrs.
I uused following command,
For Export:
C:\ulsdev/ulsdev@uls.infotech.com file=ulsdump.dmp log=ulslog.log

For Import:
C:\ulsrepay/ulsrepay@uls.infotech.com file=ulsdump.dmp fromuser=ulsdev touser=ULSREPAY log=ulslogimp.log

Re: Import -Export [message #382406 is a reply to message #382404] Thu, 22 January 2009 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 63937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase buffer size.

Re: Import -Export [message #382473 is a reply to message #382404] Thu, 22 January 2009 08:13 Go to previous message
Messages: 4626
Registered: February 2005
Location: East Coast USA
Senior Member
Not enough info. To me, it's not surprising to have an import take 3-6 times longer than an export.
Were the tables and indexes precreated in the target?
Do you have any LONG columns?
System load?
Previous Topic: export and import problem
Next Topic: Passing file name as parameter from a Concurrent Program, to a control file.
Goto Forum:

Current Time: Thu Oct 27 22:19:27 CDT 2016

Total time taken to generate the page: 0.12461 seconds