Oracle DBMS_DATAPUMP_UTL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
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
Packages
What's New In 12cR1
What's New In 12cR2