ORA-29280: Invalid Directory Path ORA-06512:”SYS.UTL_FILE”

Solution :

1. Check the dba_directories, whether the directory TESTUSER is present in database or not.

SQL> select * from dba_directories where directory_name='TESTUSER';

no rows selected

2. Create the directory as below:

SQL> create directory TESTUSER as '/export/home/oracle';

Directory created.

3. Retry the operation

SQL> declare
file_open utl_file.file_type;
begin
file_open:=utl_file.fopen('TESTUSER','dbaclassa.txt','w');
utl_file.fclose(file_open);
end;
/ 2 3 4 5 6 7

PL/SQL procedure successfully completed.