utl_file_dir problem

Hi DBAs,

The developers keep complaining about that they cannot write files
to some directories which I verified specified in init parameter file.
We define a lot of directories contiguously in the parameter file.

The problem is that:
use: show parameter utl_file_dir;
It turns out only half of them specified in the init file.
It looks like be cut off.

Is there any limit about the number of directory specified in the
init file?

Thanks,

Lily

Is is possible that one of the UTL_FILE_DIR parameters points to an invalid directory. You should make sure that all of the directories can be reached from the database server.

I'm not aware of a maximum number of directories that you can reference with UTL_FILE_DIR.

Also, If you are using 9i a better way to give file acces to programs is to use the CREATE DIRECTORY command and create a directory pointer for every dirctory where you need to give access.

In case you are interested here is a link to tahiti with more information on CREATE DIR

tahiti.oracle.com

Thanks for the reply.

I checked the operating system. All the directories are there and
the mode is fine.

I just join the team in the middle of the development process. Personally I like the way-create directory.

I did some experiments.
I changed the sequence of the utl_file_dir specified in the init
file. It is always cut off at the point of specifying
the 16th utl_file_dir.

This note is from Tahiti.oracle.com.

Quote:

---

Note:
If you list multiple values, all entries of this parameter must be on contiguous lines of the parameter file. If you separate them with other parameters, Oracle will read only the last (contiguous) lines.

---