| General Information |
| Purpose |
Creates DataPump Heterogeneous Object Types |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsmetd.sql |
| Dependencies |
|
| 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 |