Oracle DBMS_METADATA_DPBUILD
Version 19.3

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 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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx