Hello,

How do you list the files contained in a directory database object in
Oracle?

I'm working with some dumps made with expdp on Oracle 11.2.0.1.0. We say
something like this:

expdp scott/tiger@DEVDB DIRECTORY=build_dumps DUMPFILE=${timestamp}.dmp

Then later:

impdp scott/tiger@DEVDB DIRECTORY=build_dumps DUMPFILE=${timestamp}.dmp

With lots of extra parameters, of course.

'build-dumps' here is the name of a directory object which our DBA set up,
something like this:

CREATE DIRECTORY build_dumps AS '/var/whatever/data';

The trouble is, at the point at which we want to load a dump, we don't
actually know if the dump exists or not. If it doesn't, that's fine, we
can run a build process to set the database up, rather than using the
dump. But we do need to be able to tell if the dump exists, so we can
decide what to do. How can we do this?

At the moment, we just run impdp, and if it doesn't work, we assume it's
probably the file being missing, and run the build process. I'd like to be
a bit more elegant than this, though.

Thanks,
tom

--
The term Nihilartikel for a fictitious entry originated at the German
Wikipedia but was later identified as a hoax. -- Wikipedia

In article <alpine.DEB.1.10.1006241820020.28635 (AT) urchin (DOT) earth.li>,
Tom Anderson <twic (AT) urchin (DOT) earth.li> wrote:

If you know a location and filename, you can use UTL_FILE.FGETATTR:

<http://download.oracle.com/docs/cd/E...0577/u_file.ht
m#i1003488>

--
John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>