Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to set a directory and its subdirectory in utl_file_dir using command

551330Dec 14 2006 — edited Dec 14 2006
Hi all ,
Please help me in this dbt .
in one article i saw

UTL_FILE_DIR lets you specify one or more directories that Oracle should use for PL/SQL file I/O. If you are specifying multiple directories, you must repeat the UTL_FILE_DIR parameter for each directory
on separate lines of the initialization parameter file

and in another alter system set utl_file_dir=dir1,dir2 scope=both;

whther the second method is possible

if i want to have a directory and its sub directory to set in utl_file_dir
what i should do , whether i want to specify main directory and all sub directory seperated by comma or any other method is there

Please help me

thanks in advance ..........
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2007
Added on Dec 14 2006
3 comments
1,203 views