Oracle DBMS_MASTER_TABLE
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
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
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
Provides basic export info dbms_master_table.export_info(mt_name IN VARCHAR2);
TBD
 
FORMAT_TABLE_DATA_MSG
Undocumented dbms_master_table.format_table_data_msg(
table_data_size IN NUMBER)
RETURN VARCHAR2;
TBD
 
IMPORT_INFO
Provides basic import info dbms_master_table.import_info(mt_name IN VARCHAR2);
TBD
 
IMPORT_MAX_CREATION_LEVEL
Get max creation levels for remaining tables dbms_master_table.import_max_creation_level(mt_name IN VARCHAR2);
TBD
 
IMPORT_NEXT_CREATION_LEVEL
Get next creation levels for remaining tables dbms_master_table.import_next_creation_level(mt_name IN VARCHAR2);
TBD
 
IMPORT_REMAINING_TABLES
Provides remaining table data info dbms_master_table.import_remaining_tables(mt_name IN VARCHAR2);
TBD
 
OBJECTS_LEFT_TO_IMPORT
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
Provides details of table objects left to import dbms_master_table.table_objects_left_to_import(mt_name IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Data Pump
DBMS_DATAPUMP
DBMS_DATAPUMP_UTL
PSTDY_DATAPUMP_SUPPORT
TSDP_DATAPUMP
What's New In 18cR3
What's New In 19cR2

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