Oracle DBMS_METADATA_DPBUILD
Version 11.2.0.3
 
General Information
Purpose Creates DataPump Heterogeneous Object Types
Source {ORACLE_HOME}/rdbms/admin/dbmsmetd.sql
Dependencies
DBMS_METADATA_BUILD
Security Model Execute is granted to the EXECUTE_CATALOG_ROLE role.
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
 
 
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-2013 Daniel A. Morgan All Rights Reserved