We add the path in the dba_diretories and avoid the change to the
initSID.ora (therefore, you don't have to bounce the instance, and can
create as many directories as you need).
We leave the utl_file_dir set to * in the initSID.ora.

Exp:

SQL> desc dba_directories;
Name Null? Type
----------------------------------------- --------
----------------------------
OWNER NOT NULL VARCHAR2(30)
DIRECTORY_NAME NOT NULL VARCHAR2(30)
DIRECTORY_PATH VARCHAR2(4000)

create directory TESTDIRECTORY as '/ora020/test/';
grant read on directory TESTDIRECTORY to dba;
grant write on directory TESTDIRECTORY to dba;


Hope this help.

------------------------------------------------------------------------
----
David Chiu


-----Original Message-----
From: Gyanjit Kanungo
[mailto:oracledba-ezmlmshield-x51166697.[Email address protected]
Sent: Thursday, September 08, 2005 11:29 AM
To: LazyDBA Discussion
Subject: UTL_FILE file problem

I couldn't give a value different from * for the utl_file_dir parameter
in the initSid.ora file.
I tried things like C:\tmp or C:\windows\tmp, but I always have an
INVALID_PATH error.
But the same script works in the Unix environment whether the value for
the utl_file_dir is * or any existing directory.
Is there something that I missed ?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page