Oracle | DBMS_METADATA

Oracle DBMS_METADATA_DPBUILD Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

      

      PL/SQL procedure successfully completed.