Oracle DBMS_METADATA_DPBUILD
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Creates DataPump Heterogeneous Object Types
AUTHID CURRENT_USER
Dependencies
DBMS_METADATA DBMS_OUTPUT DBMS_STANDARD
DBMS_METADATA_BUILD    
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 (new 12.2)
Set the internal debug switch dbms_metadata_dpbuild.set_debug(on_off IN BOOLEAN);
exec dbms_metadata_dpbuild.set_debug(TRUE);

Related Topics
DataPump
DBMS_DATAPUMP
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DIFF
DBMS_METADATA_HACK
DBMS_METADATA_INT
DBMS_METADATA_UTIL
Packages
What's New In 12cR1
What's New In 12cR2

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