Re: Question about Oracle and DBA_DIRECTORIES

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 11 Feb 2011 16:27:40 +0000
Message-ID: <AANLkTimJ+8U_V66VkQ9QY7srqiApWiObDBsvjo3t2mN5_at_mail.gmail.com>

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_at_gmail.com> wrote:

> So the right and left slashes are valid?
>
>
> On Fri, Feb 11, 2011 at 10:10 AM, Subodh Deshpande <
> deshpande.subodh_at_gmail.com> 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_at_gmail.com> 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

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

Received on Fri Feb 11 2011 - 10:27:40 CST