ORA-29280: invalid directory path tips
Oracle Error Tips by Stephanie F.
The Oracle docs note this on the
- ORA-29280: invalid directory
corresponding directory object does not exist.
the directory object parameter, or create a corresponding
directory object with the CREATE DIRECTORY command.
This error is common when a fully-qualified
path name cannot be determined, and the most common cause of the ORA-29280 error
is a missing directory declaration. The utl_file_fcopy procedure accepts
these arguments (location, filename, dest_dir, dest_file, start_line,
create directory alert_dir as
create directory tempdir as '/tmp';
src_location => 'alert_dir',
src_filename => 'alert_log',
dest_location => 'tempdir',
dest_filename => 'alert_keep',
start_line => 1,
Oracle FAQ's Forums, a user
was confronted by ORA-29280 when attempting to generate a .txt-file. The
path had been dropped and Declared several times, but ORA-29280 continued to be
Two replies were offered to resolve ORA-29280:
- Be sure that the OS level user has
permission to write to a folder
- Try upper case letters for the
- i.e. instead of
out_dir use OUT_DIR
The latter of the two successfully resolved
ORA-29280 for the user.
UTL_FILE.FCOPY('C', 'test.sql' , 'C', 'test2.sql', 1, 6);