Oracle | DBMS_METADATA

Oracle DBMS_METADATA_DPBUILD Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Creates DataPump Heterogeneous Object Types

AUTHID CURRENT_USER

Dependencies

DBMS_METADATA	DBMS_OUTPUT	DBMS_UTILITY
DBMS_METADATA_BUILD	DBMS_STANDARD

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/dbmsmetd.sql

Subprograms

CREATE_DATABASE_EXPORT	CREATE_TABLE_EXPORT	SET_DEBUG
CREATE_SCHEMA_EXPORT	CREATE_TRANSPORTABLE_EXPORT

CREATE_DATABASE_EXPORT

Create database export dbms_metadata_dpbuild.create_database_export;

See demo below

CREATE_SCHEMA_EXPORT

Create schema export dbms_metadata_dpbuild.create_schema_export;

See demo below

CREATE_TABLE_EXPORT

Create table export dbms_metadata_dpbuild.create_table_export;

-- the following is the contents of $ORACLE_HOME/rdbms/admin/catmet2.sql.

      -- the inconsistent coding is Oracle's not mine.

      

      exec dbms_metadata_build.set_debug(false);

      exec DBMS_METADATA_DPBUILD.create_table_export;

      exec DBMS_METADATA_DPBUILD.create_schema_export;

      exec DBMS_METADATA_DPBUILD.create_database_export;

      exec DBMS_METADATA_DPBUILD.create_transportable_export;

      

      -- load XSL stylesheets

      

      exec SYS.DBMS_METADATA_UTIL.LOAD_STYLESHEETS;

CREATE_TRANSPORTABLE_EXPORT

Create transport export dbms_metadata_dpbuild.create_transportable_export;

See demo above

SET_DEBUG

Set the internal debug switch dbms_metadata_dpbuild.set_debug(on_off IN BOOLEAN);

exec dbms_metadata_dpbuild.set_debug(TRUE);

div>