Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: weasel@spray.se (Weasel)
Newsgroups: comp.databases.oracle.misc
Subject: Re: select info from a DIRECTORY?
Date: 5 May 2002 07:19:04 -0700
Organization: http://groups.google.com/
Lines: 20
Message-ID: <2b3bdf2c.0205050619.7e8893a1@posting.google.com>
References: <2b3bdf2c.0205022347.29ca850a@posting.google.com> <178d2795.0205030542.766b79ac@posting.google.com>
NNTP-Posting-Host: 217.215.95.50
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1020608344 9469 127.0.0.1 (5 May 2002 14:19:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 5 May 2002 14:19:04 GMT
Xref: easynews comp.databases.oracle.misc:81197
X-Received-Date: Sun, 05 May 2002 07:16:39 MST (news.easynews.com)

Thanks Mark, those two were just what I needed.

mark.powell@eds.com (Mark D Powell) wrote in message news:<178d2795.0205030542.766b79ac@posting.google.com>...
> weasel@spray.se (Weasel) wrote in message news:<2b3bdf2c.0205022347.29ca850a@posting.google.com>...
> > I' have a DIRECTORY on a 9i set up as:
> > create directory BFILE_DIR as 'c:\images'
> > Is there a way to find out with SQL what physical directory BFILE_DIR
> > is created with?
> > What I'm after is getting info from BFILE_DIR with SQL and use it in
> > at Java app.
> > 
> > Thanks Weasel
> 
> Weasel, what do you mean by "physical directory"?  An Oracle directory
> object is just a dictionary entry that is referenced, say by utl_file,
> to locate external files.  The referenced objects are created/removed
> independent of the database.  You can see the directories defined to
> Oracle in the all_directories and dba_directories dictionary views.
> 
> HTH -- Mark D Powell --