Oracle KU$_DPLOAD
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Loads the entire Data Pump utility including the metadata layer.

At the end of the dpload.sql script this package is dropped.
AUTHID DEFINER
Dependencies
DBMS_LOB DBMS_SYSTEM KU$_DPLOCK
DBMS_REGISTRY DBMS_UTILITY UTL_FILE
DBMS_STANDARD    
Documented No
First Available 19c
Security Model Owned by SYS with no privileges granted
Source

Note: Running dpload.sql is time consuming and resource intensive. See KU$_DPLOAD for details.		 {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
FINAL_PHASE INITIAL_PHASE RESET_VARS
FINISH PREPARE SAVE_VARS
 
FINAL_PHASE (new 23ai)
Undocumented ku$_dpload.final_phase;
TBD
 
FINISH (new 23ai)
Undocumented ku$_dpload.finish RETURN CLOB;
TBD
 
INITIAL_PHASE (new 23ai)
Undocumented ku$_dpload.iniital_phase;
TBD
 
PREPARE (new 23ai)
Undocumented ku$_dpload.prepare(
filename       IN VARCHAR2,
initial_ver    IN VARCHAR2 DEFAULT NULL,
before_ver     IN VARCHAR2 DEFAULT NULL,
new_types      IN VARCHAR2 DEFAULT NULL,
prvtkupc_split IN VARCHAR2 DEFAULT NULL,
catdpb_split   IN VARCHAR2 DEFAULT NULL,
skip_if_pdb    IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
RESET_VARS (new 23ai)
Undocumented ku$_dpload.reset_vars(invars IN CLOB);
TBD
 
SAVE_VARS (new 23ai)
Undocumented ku$_dpload.save_vars(outvars OUT CLOB);
TBD

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

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved