Oracle DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_UTL Version 11.2.0.3

General Information

Purpose

This package, with its two procedures, is undocumented by Oracle.

AUTHID

DEFINER

Dependencies

DBA_DIRECTORIES	DBMS_SYSTEM	V$DATABASE
DBMS_ASSERT	UTL_FILE	V$INSTANCE

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/prvtdput.plb

Subprograms

CREATE_DEFAULT_DIR

REPLACE_DEFAULT_DIR

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;
/

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';