Oracle | DBMS_METADATA

Oracle DBMS_METADATA_DPBUILD Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Creates DataPump Heterogeneous Object Types

AUTHID CURRENT_USER

Dependencies

DBMS_METADATA	DBMS_OUTPUT	DBMS_SYS_ERROR
DBMS_METADATA_BUILD	DBMS_STANDARD	DBMS_UTILITY

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);