Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 22.214.171.124 to 126.96.36.199.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
Owned by SYS with ? granted to ???
DROP_ORPHANED_JOBS (new 12.2)
Drop orphaned jobs that were failed due to some error
DROP_ORPHANED_JOBS_BY_DATE (new 12.2)
Drop orphaned jobs that were created before a certain date
dbms_master_table.drop_orphaned_jobs_by_date(date1 IN DATE);
EXPORT_INFO (new 12.2)
Provides basic export info
dbms_master_table.export_info(mt_name IN VARCHAR2);
FORMAT_TABLE_DATA_MSG (new 12.2)
table_data_size IN NUMBER)
IMPORT_INFO (new 12.2)
Provides basic import info
dbms_master_table.import_info(mt_name IN VARCHAR2);
IMPORT_MAX_CREATION_LEVEL (new 12.2)
Get max creation levels for remaining tables
dbms_master_table.import_max_creation_level(mt_name IN VARCHAR2);
IMPORT_NEXT_CREATION_LEVEL (new 12.2)
Get next creation levels for remaining tables
dbms_master_table.import_next_creation_level(mt_name IN VARCHAR2);
IMPORT_REMAINING_TABLES (new 12.2)
Provides remaining table data info
dbms_master_table.import_remaining_tables(mt_name IN VARCHAR2);
OBJECTS_LEFT_TO_IMPORT (new 12.2)
Provides details of objects left to export, import
dbms_master_table.objects_left_to_import(mt_name IN VARCHAR2);
TABLE_OBJECTS_LEFT_TO_IMPORT (new 12.2)
Provides details of table objects left to import
dbms_master_table.table_objects_left_to_import(mt_name IN VARCHAR2);