| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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;
PL/SQL procedure successfully completed. |
| |
| 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);
PL/SQL procedure successfully completed. |
| |
| 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 |