Oracle DBMS_DATAPUMP_UTL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
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);

Related Topics
AMGT$DATAPUMP
DataPump Executable
DBMS_DATAPUMP
DBMS_DATAPUMP_INT
Packages
What's New In 12cR1
What's New In 12cR2