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
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