Oracle KU$_DPLOAD
Version 21c

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 Loads the entire Data Pump utility including the metadata layer.

At the end of the dpload.sql script the package is dropped.
AUTHID DEFINER
Dependencies
DBMS_OUTPUT DBMS_SYSTEM KU$_DPLOCK
DBMS_REGISTRY DBMS_UTILITY UTL_FILE
DBMS_STANDARD DUAL  
Documented No
First Available 19c
Security Model Owned by SYS with no privileges granted
Undocumented {ORACLE_HOME}/rdbms/admin/dpload.sql
SQL> @?/rdbms/admin/dpload.sql

SELECT owner, object_name, object_type
FROM dba_objects
WHERE created > SYSDATE-1/24
ORDER BY 1,3,2;

OWNER   OBJECT_NAME                  OBJECT_TYPE
------- ---------------------------- ------------------
AUDSYS  SYS_IL0000019845C00030$$     INDEX PARTITION
AUDSYS  SYS_IL0000019845C00031$$     INDEX PARTITION
AUDSYS  SYS_IL0000019845C00097$$     INDEX PARTITION
AUDSYS  SYS_LOB0000019845C00030$$    LOB PARTITION
AUDSYS  SYS_LOB0000019845C00031$$    LOB PARTITION
AUDSYS  SYS_LOB0000019845C00097$$    LOB PARTITION
AUDSYS  AUD$UNIFIED TABLE            PARTITION
PUBLIC  KU$_LOGENTRY1010             SYNONYM
PUBLIC  KU$_LOGLINE1010              SYNONYM
SYS     IMPDP_STATS                  INDEX
SYS     KU$XKTFBUE_I                 INDEX
SYS     SYS_IL0000162014C00036$$     INDEX
SYS     SYS_IL0000162025C00030$$     INDEX
SYS     SYS_IL0000162025C00031$$     INDEX
SYS     SYS_IL0000162031C00097$$     INDEX
SYS     SYS_IL0000162031C00111$$     INDEX
SYS     SYS_IL0000162036C00086$$     INDEX
SYS     SYS_IL0000162036C00100$$     INDEX
SYS     SYS_IL0000162041C00095$$     INDEX
SYS     SYS_IL0000162044C00091$$     INDEX
SYS     SYS_IL0000162047C00090$$     INDEX
SYS     SYS_IL0000162050C00082$$     INDEX
SYS     SYS_LOB0000162014C00036$$    LOB
SYS     SYS_LOB0000162025C00030$$    LOB
SYS     SYS_LOB0000162025C00031$$    LOB
SYS     SYS_LOB0000162031C00097$$    LOB
SYS     SYS_LOB0000162031C00111$$    LOB
SYS     SYS_LOB0000162036C00086$$    LOB
SYS     SYS_LOB0000162036C00100$$    LOB
SYS     SYS_LOB0000162041C00095$$    LOB
SYS     SYS_LOB0000162044C00091$$    LOB
SYS     SYS_LOB0000162047C00090$$    LOB
SYS     SYS_LOB0000162050C00082$$    LOB
SYS     KU$_DPLOAD                   PACKAGE      -- normally dropped after script
SYS     KU$_DPLOCK                   PACKAGE      -- normally dropped after script
SYS     KU$_DPLOAD                   PACKAGE BODY -- normally dropped after script
SYS     KU$_DPLOCK                   PACKAGE BODY -- normally dropped after script
SYS     DATA_PUMP_XPL_TABLE$         TABLE
SYS     IMPDP_STATS                  TABLE
SYS     KU$NOEXP_TAB                 TABLE
SYS     KU$XKTFBUE                   TABLE
SYS     KU$_DATAPUMP_MASTER_10_1     TABLE
SYS     KU$_DATAPUMP_MASTER_11_1     TABLE
SYS     KU$_DATAPUMP_MASTER_11_1_0_7 TABLE
SYS     KU$_DATAPUMP_MASTER_11_2     TABLE
SYS     KU$_DATAPUMP_MASTER_12_0     TABLE
SYS     KU$_DATAPUMP_MASTER_12_2     TABLE
SYS     KU$_LIST_FILTER_TEMP         TABLE
SYS     KU$_LIST_FILTER_TEMP_2       TABLE
SYS     KU$_SHARD_DOMIDX_NAMEMAP     TABLE
SYS     KU$_USER_MAPPING_VIEW_TBL    TABLE
SYS     KU_NOEXP_TAB                 TABLE
SYS     KU_UTLUSE                    TABLE
SYS     KU$_LOGENTRY1010             TYPE
SYS     KU$_LOGLINE1010              TYPE
SYS     KUPC$_ADD_DEVICE             TYPE
SYS     KUPC$_ADD_FILE               TYPE
SYS     KUPC$_API_ACK                TYPE
SYS     KUPC$_BAD_FILE               TYPE
SYS     KUPC$_CHECKSUM_FILE          TYPE
SYS     KUPC$_COMPLETE_IMP_OBJECT    TYPE
SYS     KUPC$_DATA_FILTER            TYPE
SYS     KUPC$_DATA_REMAP             TYPE
SYS     KUPC$_DEVICE_IDENT           TYPE
SYS     KUPC$_DISK_FILE              TYPE
SYS     KUPC$_ENCODED_PWD            TYPE
SYS     KUPC$_ESTIMATE_JOB           TYPE
SYS     KUPC$_EXIT                   TYPE
SYS     KUPC$_FILEINFO               TYPE
SYS     KUPC$_FILELIST               TYPE
SYS     KUPC$_FILE_LIST              TYPE
SYS     KUPC$_FIXUP_VIRTUAL_COLUMN   TYPE
SYS     KUPC$_GET_WORK               TYPE
SYS     KUPC$_JOBINFO                TYPE
SYS     KUPC$_LOAD_DATA              TYPE
SYS     KUPC$_LOAD_METADATA          TYPE
SYS     KUPC$_LOBPIECES              TYPE
SYS     KUPC$_LOGENTRIES             TYPE
SYS     KUPC$_LOG_ENTRY              TYPE
SYS     KUPC$_LOG_ERROR              TYPE
SYS     KUPC$_MASTERERROR            TYPE
SYS     KUPC$_MASTERJOBINFO          TYPE
SYS     KUPC$_MASTER_KEY_EXCHANGE    TYPE
SYS     KUPC$_MASTER_MSG             TYPE
SYS     KUPC$_MESSAGE                TYPE
SYS     KUPC$_METADATA_FILTER        TYPE
SYS     KUPC$_METADATA_REMAP         TYPE
SYS     KUPC$_METADATA_TRANSFORM     TYPE
SYS     KUPC$_OPEN                   TYPE
SYS     KUPC$_POST_MT_INIT           TYPE
SYS     KUPC$_PREPARE_DATA           TYPE
SYS     KUPC$_RECOMP                 TYPE
SYS     KUPC$_RELEASE_FILES          TYPE
SYS     KUPC$_RESTART                TYPE
SYS     KUPC$_RESTORE_LOGGING        TYPE
SYS     KUPC$_SEQUENTIAL_FILE        TYPE
SYS     KUPC$_SET_PARALLEL           TYPE
SYS     KUPC$_SET_PARAMETER          TYPE
SYS     KUPC$_SHADOW_KEY_EXCHANGE    TYPE
SYS     KUPC$_SHADOW_MSG             TYPE
SYS     KUPC$_SQL_FILE_JOB           TYPE
SYS     KUPC$_START_JOB              TYPE
SYS     KUPC$_STOP_JOB               TYPE
SYS     KUPC$_STOP_WORKER            TYPE
SYS     KUPC$_TABLE_DATA             TYPE
SYS     KUPC$_TABLE_DATAS            TYPE
SYS     KUPC$_TABLE_DATA_ARRAY       TYPE
SYS     KUPC$_TYPE_COMP_READY        TYPE
SYS     KUPC$_UNLOAD_DATA            TYPE
SYS     KUPC$_UNLOAD_METADATA        TYPE
SYS     KUPC$_WORKERERROR            TYPE
SYS     KUPC$_WORKER_EXIT            TYPE
SYS     KUPC$_WORKER_FILE            TYPE
SYS     KUPC$_WORKER_FILE_LIST       TYPE
SYS     KUPC$_WORKER_GET_PWD         TYPE
SYS     KUPC$_WORKER_LOG_ENTRY       TYPE
SYS     KUPC$_WORKER_MSG             TYPE
SYS     KUPC$_ADD_DEVICE             TYPE BODY
SYS     KUPC$_ADD_FILE               TYPE BODY
SYS     KUPC$_API_ACK                TYPE BODY
SYS     KUPC$_BAD_FILE               TYPE BODY
SYS     KUPC$_CHECKSUM_FILE          TYPE BODY
SYS     KUPC$_COMPLETE_IMP_OBJECT    TYPE BODY
SYS     KUPC$_DATA_FILTER            TYPE BODY
SYS     KUPC$_DATA_REMAP             TYPE BODY
SYS     KUPC$_DEVICE_IDENT           TYPE BODY
SYS     KUPC$_DISK_FILE              TYPE BODY
SYS     KUPC$_ENCODED_PWD            TYPE BODY
SYS     KUPC$_ESTIMATE_JOB           TYPE BODY
SYS     KUPC$_EXIT                   TYPE BODY
SYS     KUPC$_FILEINFO               TYPE BODY
SYS     KUPC$_FILE_LIST              TYPE BODY
SYS     KUPC$_FIXUP_VIRTUAL_COLUMN   TYPE BODY
SYS     KUPC$_GET_WORK               TYPE BODY
SYS     KUPC$_JOBINFO                TYPE BODY
SYS     KUPC$_LOAD_DATA              TYPE BODY
SYS     KUPC$_LOAD_METADATA          TYPE BODY
SYS     KUPC$_LOG_ENTRY              TYPE BODY
SYS     KUPC$_LOG_ERROR              TYPE BODY
SYS     KUPC$_MASTERERROR            TYPE BODY
SYS     KUPC$_MASTERJOBINFO          TYPE BODY
SYS     KUPC$_MASTER_KEY_EXCHANGE    TYPE BODY
SYS     KUPC$_MESSAGE                TYPE BODY
SYS     KUPC$_METADATA_FILTER        TYPE BODY
SYS     KUPC$_METADATA_REMAP         TYPE BODY
SYS     KUPC$_METADATA_TRANSFORM     TYPE BODY
SYS     KUPC$_OPEN                   TYPE BODY
SYS     KUPC$_POST_MT_INIT           TYPE BODY
SYS     KUPC$_PREPARE_DATA           TYPE BODY
SYS     KUPC$_RECOMP                 TYPE BODY
SYS     KUPC$_RELEASE_FILES          TYPE BODY
SYS     KUPC$_RESTART                TYPE BODY
SYS     KUPC$_RESTORE_LOGGING        TYPE BODY
SYS     KUPC$_SEQUENTIAL_FILE        TYPE BODY
SYS     KUPC$_SET_PARALLEL           TYPE BODY
SYS     KUPC$_SET_PARAMETER          TYPE BODY
SYS     KUPC$_SHADOW_KEY_EXCHANGE    TYPE BODY
SYS     KUPC$_SQL_FILE_JOB           TYPE BODY
SYS     KUPC$_START_JOB              TYPE BODY
SYS     KUPC$_STOP_JOB               TYPE BODY
SYS     KUPC$_STOP_WORKER            TYPE BODY
SYS     KUPC$_TABLE_DATA_ARRAY       TYPE BODY
SYS     KUPC$_TYPE_COMP_READY        TYPE BODY
SYS     KUPC$_UNLOAD_DATA            TYPE BODY
SYS     KUPC$_UNLOAD_METADATA        TYPE BODY
SYS     KUPC$_WORKERERROR            TYPE BODY
SYS     KUPC$_WORKER_EXIT            TYPE BODY
SYS     KUPC$_WORKER_FILE            TYPE BODY
SYS     KUPC$_WORKER_FILE_LIST       TYPE BODY
SYS     KUPC$_WORKER_GET_PWD         TYPE BODY
SYS     KUPC$_WORKER_LOG_ENTRY       TYPE BODY
SYS     KU$_USER_MAPPING_VIEW        VIEW

172 rows selected.
Subprograms
CHECK_FOR_TYPES_PATCH FOR_VERSION RELEASE_SWLOCK
 
CHECK_FOR_TYPES_PATCH
Undocumented ku$_dpload.check_for_types_patch;
exec ku$_dpload.check_for_types_patch;

PL/SQL procedure successfully completed.
 
FOR_VERSION
Undocumented ku$_dpload.for_version(
v_filename IN VARCHAR2,
v_begin    IN VARCHAR2 DEFAULT NULL,
v_until    IN VARCHAR2 DEFAULT NULL,
new_types  IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
RELEASE_SWLOCK
Undocumented ku$_dpload.release_swlock RETURN VARCHAR2;
SELECT ku$_dpload.release_swlock
FROM dual;

RELEASE_SWLOCK
-------------------------
?/rdbms/admin/nothing.sql

Related Topics
Built-in Functions
Built-in Packages
KU$_DPLOCK
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx