Oracle 12cR2 DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_UTL Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

Purpose Internal utilities supporting DataPump functionality

AUTHID DEFINER

Dependencies

DBA_DIRECTORIES	DBMS_METADATA	KUPM$MCP
DBMS_ASSERT	DBMS_SYSTEM	UTL_FILE
DBMS_DATAPUMP	KUPCC	V$DATABASE
DBMS_LOB	KUPF$FILE	V$INSTANCE

Documented No

First Available Not known but probably 10gR1

Security Model Owned by SYS with no privileges granted

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

Subprograms

CREATE_DEFAULT_DIR	INSTANCE_CALLOUT_IMP	REPLACE_DEFAULT_DIR
EXTRACT_ELEMENT	INSTANCE_EXPORT_ACTION	SYSTEM_CALLOUT_IMP

CREATE_DEFAULT_DIR

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

BEGIN

        dbms_datapump_utl.create_default_dir;

      END;

      /

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 VACHAR2);

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;

      /

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 VACHAR2, 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;

      /

REPLACE_DEFAULT_DIR

Changes the default DataPump Directory dbms_datapump_utl.replace_default_dir;

col owner format a15

      col directory_name format a25

      col directory_path format a70

      

      SELECT *

      FROM dba_directories

      ORDER BY 2;

      -- note the directory_path value of DATA_PUMP_DIR

      

      SELECT object_type, created, last_ddl_time

      FROM dba_objects

      WHERE object_name = 'DATA_PUMP_DIR';

      

      exec dbms_datapump_utl.replace_default_dir;

      

      SELECT object_type, created, last_ddl_time

      FROM dba_objects

      WHERE object_name = 'DATA_PUMP_DIR';

SYSTEM_CALLOUT_IMP

Undocumented dbms_datapump_utl.system_callout_imp(prepost IN BINARY_INTEGER);

exec dbms_datapump_utl.system_callout_imp(1);