Skip to Main Content
  • Questions
  • DBMS_DATAPUMP and DBMS_METADATA packages

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Daniel.

Asked: October 05, 2021 - 10:16 am UTC

Last updated: October 05, 2021 - 2:38 pm UTC

Version: 19.3.0.0.0

Viewed 100+ times

You Asked

hi tom

im new to datapump and i have question about the DBMS_DATAPUMP and DBMS_METADATA and what exactly this 2 package do

from what i know package DBMS_DATAPUMP is used to export and import data and metadata

And package DBMS_METADATA is used to copy the ddl to create tablespace,table,constrainct,and many more

is this true? or i have wrong undestanding about these 2 package

thank you

and Chris said...

The docs are a good place to get information about these packages.

Looking at these you'll see

DBMS_DATAPUMP

The DBMS_DATAPUMP package is used to move all, or part of, a database between databases, including both data and metadata.

https://docs.oracle.com/en/database/oracle/oracle-database/21/arpls/DBMS_DATAPUMP.html

DBMS_METADATA

The DBMS_METADATA package provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object.

https://docs.oracle.com/en/database/oracle/oracle-database/21/arpls/DBMS_METADATA.html

So your understanding looks correct to me.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library