| General Information |
| Note: This package, with its two procedures, is undocumented by Oracle. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtdput.plb |
| Dependencies |
| DBA_DIRECTORIES |
DBMS_SYSTEM |
V$DATABASE |
| DBMS_ASSERT |
UTL_FILE |
V$INSTANCE |
|
| Security Model |
Owned by SYS with no privileges granted |
| 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;
/ |
| |
| REPLACE_DEFAULT_DIR |
| Change 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'; |
