Kalyan Ganesan
Programmer
I am familiar with the DBA_DIRECTORIES and ALL_DIRECTORIES
But i want to know how to move a excel file into Oracle Directory
Like when i run this query
select * from dba_directories
SYS ORACLE_OCM_CONFIG_DIR2 /oracle/app/oracle/product/11.2.0.4/db_risk/ccr/state
SYS DV_ADMIN_DIR /oracle/app/oracle/product/11.2.0.4/db_risk/dv/admin/
SYS INFO1CTR_TRACE_LOG /oracle/app/oracle/diag/rdbms/risk/risk/trace/
SYS LQDTN_DPUMP_DIR /landing_pad/dev
SYS ORAN /download/info1ctr/amit
SYS INFO1CTR_DIR /download/info1ctr
SYS TEST /backup/exports/ryan
SYS EXPORT /backup/exports/san
SYS DUMP /download/infamgr/dump
SYS EXPDP_TEMP /backup/exports/ITSM_C02177586
SYS ITSMC02160689 /download/ITSM/ITSMC02160689
it pulls up 100s of rows like this
i under the owner directory name and directory path are the above,but what is their system path like which drive etc
and how can i move a excel file in a directory that i can create CREATE DIRECTORY test_dir AS 'i:\project';
But i want to know how to move a excel file into Oracle Directory
Like when i run this query
select * from dba_directories
SYS ORACLE_OCM_CONFIG_DIR2 /oracle/app/oracle/product/11.2.0.4/db_risk/ccr/state
SYS DV_ADMIN_DIR /oracle/app/oracle/product/11.2.0.4/db_risk/dv/admin/
SYS INFO1CTR_TRACE_LOG /oracle/app/oracle/diag/rdbms/risk/risk/trace/
SYS LQDTN_DPUMP_DIR /landing_pad/dev
SYS ORAN /download/info1ctr/amit
SYS INFO1CTR_DIR /download/info1ctr
SYS TEST /backup/exports/ryan
SYS EXPORT /backup/exports/san
SYS DUMP /download/infamgr/dump
SYS EXPDP_TEMP /backup/exports/ITSM_C02177586
SYS ITSMC02160689 /download/ITSM/ITSMC02160689
it pulls up 100s of rows like this
i under the owner directory name and directory path are the above,but what is their system path like which drive etc
and how can i move a excel file in a directory that i can create CREATE DIRECTORY test_dir AS 'i:\project';