Oracle | DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_UTL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal utilities supporting DataPump functionality

AUTHID DEFINER

Dependencies

DATABASE_PROPERTIES	DBMS_METADATA	KUPM$MCP
DBA_DIRECTORIES	DBMS_STANDARD	KUPU$UTILITIES_INT
DBA_OBJECTS	DBMS_SYSTEM	KUPW$WORKER
DBMS_ASSERT	DBMS_SYS_ERROR	UTL_FILE
DBMS_DATAPUMP	DBMS_UTILITY	V$DATABASE
DBMS_LOB	KUPCC	V$INSTANCE

Documented No

First Available Not known but probably 10.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtdput.plb

Subprograms

CREATE_DEFAULT_DIR	EXTRACT_ELEMENT	REPLACE_DEFAULT_DIR
DISABLE_DEBUG	INSTANCE_CALLOUT_IMP	SYSTEM_CALLOUT_IMP
ENABLE_DEBUG	INSTANCE_EXPORT_ACTION

CREATE_DEFAULT_DIR

Creates the default DataPump Directory during database installation dbms_datapump_utl.create_default_dir;

exec dbms_datapump_utl.create_default_dir;

      

      PL/SQL procedure successfully completed.

DISABLE_DEBUG

Disables DataPump Debugging dbms_datapump_utl.disable_debug;

exec dbms_datapump_utl.disable_debug;

      

      PL/SQL procedure successfully completed.

ENABLE_DEBUG

Enables DataPump Debugging dbms_datapump_utl.enable_debug(loggin IN VARCHAR2);

exec dbms_datapump_utl.enable_debug('DPDEBUG');

      

      PL/SQL procedure successfully completed.

EXTRACT_ELEMENT

Undocumented dbms_datapump_utl.extract_element( string IN OUT CLOB, remaining IN OUT NUMBER, element OUT VARCHAR2, wild OUT BOOLEAN, delimiter OUT VARCHAR2);

TBD

INSTANCE_CALLOUT_IMP

Undocumented dbms_datapump_utl.instance_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN BINARY_INTEGER, action OUT VARCHAR2, alt_name OUT VARCHAR2);

DECLARE

       act VARCHAR2(30);

       alt VARCHAR2(30);

      BEGIN

        dbms_datapump_utl.instance_callout_imp('TEST', 'C##ABC', 1, 0, act, alt);

        dbms_output.put_line('Action: ' || act);

        dbms_output.put_line('Alt: ' || alt);

      END;

      /

      

      PL/SQL procedure successfully completed.

INSTANCE_EXPORT_ACTION

Undocumented dbms_datapump_utl.instance_export_action( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, tgt_version IN VARCHAR2, action OUT VARCHAR2, alt_name OUT VARCHAR2, where_clause OUT VARCHAR2);

DECLARE

       act VARCHAR2(30);

       alt VARCHAR2(30);

       whc VARCHAR2(30);

      BEGIN

        dbms_datapump_utl.instance_export_action('TEST', 'C##ABC', 1, 1, act, alt, whc);

        dbms_output.put_line('Action: ' || act);

        dbms_output.put_line('Alt: ' || alt);

        dbms_output.put_line('Where: ' || whc);

      END;

      /

      

      PL/SQL procedure successfully completed.

REPLACE_DEFAULT_DIR

Changes the default DataPump Directory from a non-default value to the default dbms_datapump_utl.replace_default_dir;

col owner format a15

      col directory_name format a25

      col directory_path format a70

      

      SELECT owner, directory_name, directory_path

      FROM dba_directories

      ORDER BY 1,2;

      

      OWNER  DIRECTORY_NAME           DIRECTORY_PATH

      ------ ------------------------ ---------------------------------------------

      SYS    DATA_PUMP_DIR            /u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/log/

      SYS    DBMS_OPTIM_ADMINDIR      /u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/admin

      SYS    DBMS_OPTIM_LOGDIR        /u01/app/oracle/product/23.0.0.0/dbhome_1/cfgtoollogs

      SYS    JAVA$JOX$CUJS$DIRECTORY$ /u01/app/oracle/product/23.0.0.0/dbhome_1/javavm/admin

      SYS    OPATCH_INST_DIR          /u01/app/oracle/product/23.0.0.0/dbhome_1/OPatch

      SYS    OPATCH_LOG_DIR           /u01/app/oracle/product/23.0.0.0/rdbms/log

      SYS    OPATCH_SCRIPT_DIR        /u01/app/oracle/product/23.0.0.0/dbhome_1/QOpatch

      SYS    ORACLE_BASE              /u01/app/oracle

      SYS    ORACLE_HOME              /u01/app/oracle/product/23.0.0.0/dbhome_1

      SYS    SDO_DIR_ADMIN            /u01/app/oracle/product/23.0.0.0/dbhome_1/md/admin

      SYS    XMLDIR                   /u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/xml

      SYS    XSDDIR                  /u01/app/oracle/product/23.0.0.0/dbhome_1/rdbms/xml/schema

      

      SELECT object_type, created, last_ddl_time

      FROM dba_objects

      WHERE object_name = 'DATA_PUMP_DIR';

      

      OBJECT_TYPE  CREATED                LAST_DDL_TIME

      ------------ --------------------- ---------------------

      DIRECTORY    06-APR-2024 09:33:27  21-MAY-2024 18:05:34

      

      exec dbms_datapump_utl.replace_default_dir;

      

      PL/SQL procedure successfully completed.

      

      SELECT object_type, created, last_ddl_time

      FROM dba_objects

      WHERE object_name = 'DATA_PUMP_DIR';

      

      OBJECT_TYPE  CREATED                LAST_DDL_TIME

      ------------ --------------------- ----------------------

      DIRECTORY    06-APR-2024 09:33:27   04-JUL-2024 16:38:05

SYSTEM_CALLOUT_IMP

Undocumented dbms_datapump_utl.system_callout_imp(prepost IN BINARY_INTEGER);

exec dbms_datapump_utl.system_callout_imp(1);

      

      PL/SQL procedure successfully completed.