RE: Question about Oracle and DBA_DIRECTORIES

I believe that at least data_pump_dir and oracle_ocm_config_dir are
created by catproc.sql (based on ORACLE_HOME), so I wouldn't just "blow
them away". Not sure about work_dir.

 

mvg / regards,

Jo Holvoet

 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
Sent: vrijdag 11 februari 2011 15:47
To: oracle-l@xxxxxxxxxxxxx
Subject: Question about Oracle and DBA_DIRECTORIES

 

I don't have much experience using directories in Oracle (Oracle 10 on
Windows Server 2003).  I've taken over an instance with very little
documentation.  I don't believe any of these directories below are
usable.

OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
-------------------------------------------------------------

SYS                            DATA_PUMP_DIR
F:\oracle\product\10.2.0/admin/starsdev/dpdump/

SYS                            WORK_DIR
F:\oracle\product\10.2.0\db/work

SYS                            ORACLE_OCM_CONFIG_DIR
F:\oracle\product\10.2.0\db/ccr/state


NOTE the combination of left \ and right / slashes.  Maybe my
predecessor was trying to combine the best of Windows and Unix.  

I'm not sure what they'd be used for and I obviously can't find them
under Windows.  I'd like some confirmation that this is just plain bad
data before I blow it away.

Other related posts: