DECLARE
fh utl_file.file_type;
BEGIN
fh := utl_file.fopen('DATA_PUMP_DIR','test.txt','W');
utl_file.put_line(fh,'hello');
utl_file.put_line(fh,'how are you');
utl_file.fclose(fh);
END;
/
SQL> set line 30
SQL> select directory_path from all_directories where directory_name='DATA_PUMP_DIR';
DIRECTORY_PATH
------------------------------
C:\app\shin/admin/orcl/dpdump/
SQL> select table_name,privilege from user_tab_privs_recd where table_name='DATA_PUMP_DIR';
TABLE_NAME
------------------------------
PRIVILEGE
------------------------------
DATA_PUMP_DIR
READ
DATA_PUMP_DIR
WRITE