Re: Question about Oracle and DBA_DIRECTORIES

In a word yes. forward slash has been valid on Windows for years. (which
helps when you forget which o/s you are on :) - until you then type ls -l :(
).

DATA_PUMP_DIR is configured as part of the install - ORACLE_OCM_CONFIG_DIR
is configured as part of the install of the Configuration manager collector.
(CCR). WORK_DIR used to be used in a few Oracle supplied examples eg Note
562899.1.

It could be worse - this is my 11.2 play environment

SQL> select directory_name from dba_directories order by directory_name;

DIRECTORY_NAME
------------------------------
DATA_FILE_DIR
DATA_PUMP_DIR
LOG_FILE_DIR
MEDIA_DIR
ORACLE_OCM_CONFIG_DIR
SS_OE_XMLDIR
SUBDIR
XMLDIR

with my particular favourite being the XMLDIR straight out of development.

SQL> select directory_path from dba_directories order by directory_name;

DIRECTORY_PATH
--------------------------------------------------------------------------------
e:\app\oracle\product\11.2.0\dbhome_1\demo\schema\sales_history\
e:\app\oracle\product\11.2.0\dbhome_1\rdbms\log\
e:\app\oracle\product\11.2.0\dbhome_1\demo\schema\log\
e:\app\oracle\product\11.2.0\dbhome_1\demo\schema\product_media\
e:\app\oracle\product\11.2.0\dbhome_1\ccr\state
e:\app\oracle\product\11.2.0\dbhome_1\demo\schema\order_entry\
e:\app\oracle\product\11.2.0\dbhome_1\demo\schema\order_entry\/2002/Sep
c:\ade\aime_dadvfm0250\oracle\rdbms\xml




On Fri, Feb 11, 2011 at 3:52 PM, Thomas Day <tomdaytwo@xxxxxxxxx> wrote:

> So the right and left slashes are valid?
>
>
> On Fri, Feb 11, 2011 at 10:10 AM, Subodh Deshpande <
> deshpande.subodh@xxxxxxxxx> wrote:
>
>> from where did you get this...is instance and database runnign at this
>> moment..on the said host..
>> was it default installation, with flashbak enabled and
>> configuration/connectto metalink...
>> I prefer to remove the installation using delete database using dbca
>>
>> thanks..subodh
>>
>> On 11 February 2011 20:17, Thomas Day <tomdaytwo@xxxxxxxxx> wrote:
>>
>>> 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.
>>>
>>
>>
>>
>> --
>> ==============================
>> DO NOT FORGET TO SMILE TODAY
>> ==============================
>>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: