UTL_FILE, UTL_FILE_DIR and DIRECTORY, how do they affect UTL_FILE.FREMOVE?

oracle oracle10g directory utl-file
Cade Roux picture Cade Roux · Jun 17, 2011 · Viewed 11.7k times · Source

FREMOVE is failing with an error "ORA-29280: invalid directory path"

It works fine when I add the path to the UTL_FILE_DIR and restart the database.

This is regardless of having the directory as an Oracle directory with both READ and WRITE granted.

Answer

DCookie picture DCookie · Jun 17, 2011

What is the syntax you're using for FREMOVE parameter location? For a directory, you pass in the name of the Oracle Directory object, case significant.

Related questions

How to find the privileges and roles granted to a user in Oracle?

I am using Linux, Oracle10g. I have created one user called test. and granted create session and select any dictionary permission to the same user. i also granted sysdba and sysoper roles to the same users. Now i want …

Read More
Checking oracle sid and database name

I want to check SID and current database name. I am using following query for checking oracle SID select instance from v$thread; but table or view does not exist error is coming. I am using following query for checking …

Read More
CASE .. WHEN expression in Oracle SQL

I have the table with 1 column and has following data Status a1 i t a2 a3 I want to display the following result in my select query Status| STATUSTEXT a1 | Active i | Inactive t | Terminated a2 | Active a3 | Active One …

Read More