Oracle DBMS_MASTER_TABLE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. 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.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Undocumented but one of the procedures is identified as being used to "remove the datapump orphaned jobs"
AUTHID CURRENT_USER
Dependencies
DBA_DATAPUMP_JOBS DBMS_MASTER_TABLE DBMS_STANDARD
DBA_OBJECTS DBMS_OUTPUT KUPCC
DBMS_ASSERT    
Documented No
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/dbmsdpmt.sql
Subprograms
 
DROP_ORPHANED_JOBS (new 12.2)
Drop orphaned jobs that were failed due to some error dbms_master_table.drop_orphaned_jobs;
exec dbms_master_table.drop_orphaned_jobs;
 
DROP_ORPHANED_JOBS_BY_DATE (new 12.2)
Drop orphaned jobs that were created before a certain date dbms_master_table.drop_orphaned_jobs_by_date(date1 IN DATE);
exec dbms_master_table.drop_orphaned_jobs_by_date(SYSDATE-30);
 
EXPORT_INFO (new 12.2)
Provides basic export info dbms_master_table.export_info(mt_name IN VARCHAR2);
TBD
 
FORMAT_TABLE_DATA_MSG (new 12.2)
Undocumented dbms_master_table.format_table_data_msg(
table_data_size IN NUMBER)
RETURN VARCHAR2;
TBD
 
IMPORT_INFO (new 12.2)
Provides basic import info dbms_master_table.import_info(mt_name IN VARCHAR2);
TBD
 
IMPORT_MAX_CREATION_LEVEL (new 12.2)
Get max creation levels for remaining tables dbms_master_table.import_max_creation_level(mt_name IN VARCHAR2);
TBD
 
IMPORT_NEXT_CREATION_LEVEL (new 12.2)
Get next creation levels for remaining tables dbms_master_table.import_next_creation_level(mt_name IN VARCHAR2);
TBD
 
IMPORT_REMAINING_TABLES (new 12.2)
Provides remaining table data info dbms_master_table.import_remaining_tables(mt_name IN VARCHAR2);
TBD
 
OBJECTS_LEFT_TO_IMPORT (new 12.2)
Provides details of objects left to export, import dbms_master_table.objects_left_to_import(mt_name IN VARCHAR2);
TBD
 
TABLE_OBJECTS_LEFT_TO_IMPORT (new 12.2)
Provides details of table objects left to import dbms_master_table.table_objects_left_to_import(mt_name IN VARCHAR2);
TBD

Related Topics
Data Pump
DBMS_DATAPUMP
DBMS_DATAPUMP_UTL
Packages
PSTDY_DATAPUMP_SUPPORT
TSDP_DATAPUMP
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