performance diff in exp & expdp [message #459229] |
Fri, 04 June 2010 01:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Riyasbasha
Messages: 25 Registered: March 2010
|
Junior Member |
|
|
Hi All
I export a table using exp utility it take 30 mins to complete the export.
The same i have done in expdp utility it take 10 mins to complete the export.
How it happens?
can any one help me.
|
|
|
Re: performance diff in exp & expdp [message #459230 is a reply to message #459229] |
Fri, 04 June 2010 01:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
2 different tools, each one has its pros and cons, you found an advantage for your case.
Now if you want more you have to detail what you did including where you launch your commands, the syntax you use, the versions and so on.
Regards
Michel
[Updated on: Fri, 04 June 2010 01:40] Report message to a moderator
|
|
|
|
Re: performance diff in exp & expdp [message #459241 is a reply to message #459233] |
Fri, 04 June 2010 02:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
expdp and exp are 2 different tools, no common code, no common file format, nothing in common, so comparing their performances is meaningless.
Regards
Michel
|
|
|