|
|
|
|
|
|
|
|
| Re: Diffrence between object export using expdp and dbms_metadata [message #441480 is a reply to message #441454] |
Mon, 01 February 2010 05:55   |
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
|
Senior Member |
|
|
Hi,
I want to export the metadata of database/schema/object. I need to use DBMS_METADATA. By using expdp, datapump also we can do the same. Could you please tell me why this is preferable? any additional advantages? Please send me link if any.
In the same way, in my next requirement, i need to use DBMS_DATAPUMP to export/import the data of database/schema/object. In this case why it is preferable?
Why expdp, dbms_datapump not preferable in 1st case and why expdp is not preferable for 2nd case?
Regards,
Madhavi.
|
|
|
|
| Re: Diffrence between object export using expdp and dbms_metadata [message #441483 is a reply to message #441480] |
Mon, 01 February 2010 06:02 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Could you please tell me why this is preferable? any additional advantages?
Read what have been said.
Quote:Please send me link if any.
There is no for your specific question. Read the documentation about the 2 features.
Quote: In this case why it is preferable?
If you want to get ALL stuff, use datapump.
Quote:Why expdp, dbms_datapump not preferable in 1st case and why expdp is not preferable for 2nd case?
Which first case, which second case?
The preferable is the one you know how to use to fit the requirements you have.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
