You need to specifie in the init.ora or (spfile)
utl_file_dir='/path','/path2'...
I believe it's better create directory for security reasons also...
Hope this help!!
Serena
-----Mensaje original-----
De: gaojunguan [mailto:oracledba-ezmlmshield-x81787423.[Email address protected]
Enviado el: miércoles, 09 de enero de 2008 8:04
Para: LazyDBA Discussion
Asunto: Question about utl_file_dir
Hello, friends
OS: Linux
Oracle: 10.2
Question:
How can i use utl_file_dir to control db user manipulate files in specific loaction?
what's the difference between utl_file_dir and create directory?
Thanks & regards
Halk
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Para el medioambiente cada gesto cuenta: por favor, no imprimas este e-mail si no es realmente necesario
Este correo y sus archivos asociados son privados y confidenciales y va dirigido exclusivamente a su destinatario. Si
recibe este correo sin ser el destinatario del mismo, le rogamos proceda a su eliminacion y lo ponga en conocimiento
del emisor. La difusion por cualquier medio del contenido de este correo podría ser sancionada conforme a lo previsto
en las leyes espanyolas. No se autoriza la utilizacion con fines comerciales o para su incorporacion a ficheros
automatizados de las direcciones del emisor o del destinatario.
Each one of us can do our bit for the environment: please, do not print this e-mail unless it is absolutely essential.
This mail and its attached files are confidential and are exclusively intented to their addresses. In case you may
receive this mail not being its address, we beg you to let us know the error by reply and to proceed to delete it. The
circulation by any mean of this mail could be penalised in accordance with the Spanish legislation. The use of both
the transmitter and the addresses with a commercial aim, or in order to be incorporated to automated files,
is not authorized.
Oracle LazyDBA home page