Home » SQL & PL/SQL » SQL & PL/SQL » Diffrence between object export using expdp and dbms_metadata (oracle 10g)
Diffrence between object export using expdp and dbms_metadata [message #441454] Mon, 01 February 2010 04:37 Go to next message
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
Senior Member
Hi,
We can export the object/schema/database using expdp and also do the same thing with DBMS_METADATA package. Can you please tell me what is the diffrence between these two? What are the additional advantages for DBMS_METADATA ?
Regards,
Madhavi.
Re: Diffrence between object export using expdp and dbms_metadata [message #441457 is a reply to message #441454] Mon, 01 February 2010 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using DBMS_METADATA you can choose your objects and their parameters more finely.

Regards
Michel
Re: Diffrence between object export using expdp and dbms_metadata [message #441466 is a reply to message #441454] Mon, 01 February 2010 04:57 Go to previous messageGo to next message
madhavi babburi
Messages: 117
Registered: May 2009
Location: Hyderabad
Senior Member
Hi Michel,
Thanks for reply. Is the only advantage or more? If you have any links regarding this, Please send me.
Regards,
Madhavi.
Re: Diffrence between object export using expdp and dbms_metadata [message #441472 is a reply to message #441454] Mon, 01 February 2010 05:02 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DNMS_METADATA will only export the structures of objects - expdb will export data as well.
Re: Diffrence between object export using expdp and dbms_metadata [message #441480 is a reply to message #441454] Mon, 01 February 2010 05:55 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How to display only details of group by query
Next Topic: QUERY to get balances of running total
Goto Forum:
  


Current Time: Sat Sep 24 18:02:49 CDT 2016

Total time taken to generate the page: 0.08275 seconds