Oracle DBMS_MASTER_TABLE
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 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_ASSERT DBMS_STANDARD
DBA_OBJECTS DBMS_OUTPUT KUPCC
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