Re: select info from a DIRECTORY?

From: Mark D Powell <mark.powell_at_eds.com>
Date: 3 May 2002 06:42:04 -0700
Message-ID: <178d2795.0205030542.766b79ac@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 Fri May 03 2002 - 08:42:04 CDT