| Export dump of large table [message #450747] |
Fri, 09 April 2010 01:35  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
Hi Experts,
We have two databases running on 10.2.0.4 and 9.2.0.8.
Both are having the same unpartitioned table of size 80G.
I am exporting the table on 10g by using parallel=8 and dumpfile with %U option. That took around 4 hours to export the table.
And on 9.2.0.8, i am exporting using below parameters, taking around 5 hours.
buffer=2000000
recordlength=64000
Can you suggest me some options i can try to speed up the export in both versions.
Thanks in advance for your suggestions.
Regards
Lalit
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
