Thanks Mark, those two were just what I needed.
mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0205030542.766b79ac_at_posting.google.com>...
> weasel_at_spray.se (Weasel) wrote in message news:<2b3bdf2c.0205022347.29ca850a_at_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 --
Received on Sun May 05 2002 - 09:19:04 CDT
