Pour afficher les DIRECTORY

CREATE DIRECTORY

Create a directory – an alias for a filesystem pathname – used to store LOBs.

Syntax:

 CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';

Example

Create or replace DIRECTORY dir_test as ‘c:\test’;

declare
MyFile utl_file.file_type;

begin
MyFile := utl_file.fopen(‘DIR_TEST’, ‘some_filename.txt’, ‘w’);
utl_file.put_line(MyFile, ‘Here is some example text’);
utl_file.put_line(MyFile, ‘Another line of text’);
utl_file.fclose(MyFile);
end;
/

exemple :

CREATE OR REPLACE DIRECTORY DBA_DIR AS ‘C:\Batch’;

GRANT READ,WRITE ON DIRECTORY DBA_DIR TO OPS$DBO;

Pour lister les directories

select OWNER,DIRECTORY_NAME,DIRECTORY_PATH
from DBA_DIRECTORIES
order by OWNER,DIRECTORY_NAME;