RE: Question about Oracle and DBA_DIRECTORIES

From: Holvoet, Jo <jo.holvoet_at_thomascook.be>
Date: Fri, 11 Feb 2011 16:05:41 +0100
Message-ID: <CF9A39CD0F65EA49ADF70FCBF9BC2FF701B0DEBF_at_SW-GNETCW-MBX02.tcads.thomascook.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: vrijdag 11 februari 2011 15:47
To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 11 2011 - 09:05:41 CST