col owner format a15
col directory_name format a20
col directory_path format a70
SELECT * FROM dba_directories;
CREATE OR REPLACE DIRECTORY BACKUP AS '/var/backup';
CREATE OR REPLACE DIRECTORY SUBDIR AS '/opt/db/app/oracle/11g/demo/schema/order_entry//2002/Sep';
CREATE OR REPLACE DIRECTORY SS_OE_XMLDIR AS '/opt/db/app/oracle/11g/demo/schema/order_entry/';
CREATE OR REPLACE DIRECTORY LOG_FILE_DIR AS '/opt/db/app/oracle/11g/demo/schema/log/';
CREATE OR REPLACE DIRECTORY DATA_FILE_DIR AS '/opt/db/app/oracle/11g/demo/schema/sales_history/';
CREATE OR REPLACE DIRECTORY XMLDIR AS '/ade/b/1191423112/oracle/rdbms/xml';
CREATE OR REPLACE DIRECTORY MEDIA_DIR AS '/opt/db/app/oracle/11g/demo/schema/product_media/';
CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS '/opt/db/app/oracle/admin/GATEONE/dpdump/';
CREATE OR REPLACE DIRECTORY ORACLE_OCM_CONFIG_DIR AS '/opt/db/app/oracle/11g/ccr/state';