RE: Can relative dirs be used in CREATE DIRECTORY?
- From: "Yasin Baskan" <yasin.baskan@xxxxxxxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Apr 2008 14:46:28 +0300
Rich, relative paths start with $ORACLE_HOME/dbs.
SQL> create directory test as 'scripts';
Directory created.
SQL> r
1 declare
2 vfilehandle UTL_FILE.file_type;
3 begin
4 vfilehandle := UTL_FILE.fopen ('TEST', 'test.txt', 'w');
5 UTL_FILE.put_line (vfilehandle, 'test');
6 UTL_FILE.fclose(vfilehandle);
7* end;
PL/SQL procedure successfully completed.
$ cd $ORACLE_HOME/dbs/scripts
$ more test.txt
test
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
Sent: Wednesday, April 09, 2008 9:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Can relative dirs be used in CREATE DIRECTORY?
Hey all,
The subject about says it all. The SQL Reference docs (10.1 - 11.1) for
CREATE DIRECTORY show this example:
CREATE DIRECTORY admin AS 'oracle/admin';
...which implies a relative directory of "." in Unix. But where would
that
directory have to be created on the filesystem? I haven't been able to
find
this through trial and error and I'm not sure how one would attempt to
trace
this via strace, truss, etc.
My goal is to have changes in the filesystem automagically reflected in
the
Oracle directory object without me having to rememeber to reissue the
CREATE
DIRECTORY command manually on all databases.
Thoughts?
Rich
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
