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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.