path to oracle directories

path to dba_directories

SELECT * FROM dba_directories;

OWNER
--------------------------------------------------------------------------------------------------------------------------------

DIRECTORY_NAME
--------------------------------------------------------------------------------------------------------------------------------

DIRECTORY_PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

ORIGIN_CON_ID
-------------
SYS
DATA_PUMP_DIR
/oracle/admin/instance_name/dpdump/
0

create your own directory or change current location

CREATE DIRECTORY <directory_name> AS '<path>';
create or replace directory DATA_PUMP_DIR as '/oracle/exports/instance_name';

CREATE DIRECTORY DATA_PUMP_DIRECTORY AS '/oracle/exports/instance_name';
CREATE DIRECTORY YOUR_OWN_DIRECTORY AS '/oracle/export/your_own_directory':
(create directory before from operating system)

Page updated

Google Sites

Report abuse