UTL_FILE_DIR in Oracle
UTL_FILE_DIR parameter allow you to specify one or more directories where you can do input/output operations in PL SQL.These file can be written and can be read using UTL_FILE Package. syntax for setting UTL_FILE_DIR is alter system set UTL_FILE_DIR = ‘/tmp’ scope=spfile; Specifying multiple directories in the spfile alter system set utl_file_dir=’/tmp/dir1′,’/tmp/dir2′,’/tmp’ scope=spfile In the [...]
Written by admin on January 28th, 2011 with comments disabled.
Read more articles on Oracle Initialization Parameters.