RE: init.ora file and UTL_FILE package

(see answer below)

> -----Original Message-----
> From: Kempf, Reed [mailto:rkempf_at_rightnow.com]
>
> I have a question concerning the init.ora file and using the supplied
> package UTL_FILE....
>
> I am finding it a real inconvenience to bounce the database
> everytime I need
> to add a UTL_FILE directory, especially on the development
> machine.  Since
> the coding is very dynamic and many people are developing on the same
> database, when I add a UTL_FILE directory, I need to notify everyone
> involved, have them stop what they are doing and bounce the
> database... yuk!
>
> Is there any possible way to add UTL_FILE directories on the
> fly without
> bouncing the database (alter session, alter system, etc....)
> and then at a
> more convenient time add all of the changes at once to the
> init.ora file and
> bounce the database once.
>
> Any suggestions would be useful.

This isn't exactly what you're looking for, but did you know about this feature?

Metalink Doc ID:  Note:1016653.4
Bulletin: Steps to verify setup for UTIL_FILE Package on Windows NT ...
The security and directory accessibility are controlled by the UTL_FILE_DIR parameter. If the INIT.ORA file contains  UTL_FILE_DIR = * then database permissions are disable and all files and directories are accessible to all users. ...

Of course, when saying UTL_FILE_DIR = *, developpers can overwrite any file on which the oracle executable has write privileges. Received on Tue Oct 02 2001 - 18:18:00 CDT