Utl_file_dir has to be specified in init.ora file



You can create directory objects in the database, create directory is
recommended than the utl_file_dir



Create or replace directory <DIR_NAME> AS ''

/





Regards,





Kedar Barde

Oracle 9i DBA

Oracle Certified Associate(OCA)

Email: kedar.[Email address protected]



-----Original Message-----
From: gaojunguan
[mailto:oracledba-ezmlmshield-x81787423.[Email address protected]
Sent: 09 January 2008 07:04
To: LazyDBA Discussion
Subject: 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






"Any of the statements or comments made above should be regarded as personal and not necessarily those of Velindre NHS Trust, any constituent part or connected body

Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol ac nid o reidrwydd fel datganiadau neu sylwadau gan Ymddiriedolaeth GIG Felindre, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig a'r Ymddiriedolaeth".


Oracle LazyDBA home page