Re: How to get the complete utl_file_dir list

Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.1b6b209daee36105989cb1_at_news.individual.net>...
> In article <4d32d1be.0407230503.3bf0117b_at_posting.google.com>, Andre
> says...
> > Hello All,
> >
> > With the command:
> > CREATE DIRECTORY LOG_DIR as =3Fc:\MyDirectory';
> > I have created several directories in my oracle 9.2 database
> > CREATE DIRECTORY LOG_DIR1 as =3Fc:\MyDirectory1';
> > CREATE DIRECTORY LOG_DIR2 as =3Fc:\MyDirectory2';
> > CREATE DIRECTORY LOG_DIR3 as =3Fc:\MyDirectory3';
> >
> > But is there a way to do a select so I can see all these mappings?
> > When I execute select * from v$parameter where name = 'utl_file_dir';
> > I only get one record, and no directory is there.....
> >
>
> SQL> select * from all_directories;

You are my hero :-)

Thanks!!

Anneke
The Netherlands Received on Sun Jul 25 2004 - 23:55:50 CDT