Oracle DBMS_METADATA_DPBUILD
Version 21c

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_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 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>

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx