| Import -Export [message #382404] |
Thu, 22 January 2009 03:10  |
sr_orcl
Messages: 82
Registered: January 2009
Location: mumbai
|
Member |
|
|
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 #382473 is a reply to message #382404] |
Thu, 22 January 2009 08:13  |
joy_division
Messages: 4963
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?
Etc.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
