General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
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
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(
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
