RE: Question about Oracle and DBA_DIRECTORIES
- From: "Holvoet, Jo" <jo.holvoet@xxxxxxxxxxxxx>
- To: <tomdaytwo@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 11 Feb 2011 16:05:41 +0100
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:
