Oracle 12c DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_UTL Version 12.1.0.2

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.

Interested in Oracle GoldenGate? Check out the IGGOUG,

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

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 (new 12.1)

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 (new 12.1)

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 (new 12.1)

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 (new 12.1)

Undocumented

dbms_datapump_utl.system_callout_imp(prepost IN BINARY_INTEGER);

exec dbms_datapump_utl.system_callout_imp(1);