How to get the complete utl_file_dir list

Hello All,

With the command:

        CREATE DIRECTORY LOG_DIR as ‘c:\MyDirectory'; I have created several directories in my oracle 9.2 database

	CREATE DIRECTORY LOG_DIR1 as ‘c:\MyDirectory1';
	CREATE DIRECTORY LOG_DIR2 as ‘c:\MyDirectory2';
	CREATE DIRECTORY LOG_DIR3 as ‘c:\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.....

Thanks All,
Anneke
Te Netherlands Received on Fri Jul 23 2004 - 08:03:46 CDT