Oracle DBMS_MASTER_TABLE
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 19cR3

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
DBSecWorx