Re: Question about Oracle and DBA_DIRECTORIES
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: tomdaytwo@xxxxxxxxx
- Date: Fri, 11 Feb 2011 16:27:40 +0000
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:
