Oracle DBMS_METADATA_DPBUILD
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Creates DataPump Heterogeneous Object Types
AUTHID CURRENT_USER
Dependencies
DBMS_METADATA 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
Undocumented dbms_metadata_dpbuild.create_database_export;
See demo below
 
CREATE_SCHEMA_EXPORT
Undocumented dbms_metadata_dpbuild.create_schema_export;
See demo below
 
CREATE_TABLE_EXPORT
Undocumented 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
Undocumented dbms_metadata_dpbuild.create_transportable_export;
See demo above

Related Topics
DataPump
DBMS_DATAPUMP
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DIFF
DBMS_METADATA_HACK
DBMS_METADATA_INT
DBMS_METADATA_UTIL
Packages

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