Re: utl_file_dir

Edwin,

I have a long list of UTL_FILE_DIR lines in my Apps 11i instance, one for each directory. There are 22 lines and the total number of characters used is around 600 characters. However, 'show parameter utl_file_dir' in SQL*Plus shows only the first 512 bytes.

PLEASE NOTE: *All* the UTL_FILE_DIR lines should be kept together in the file WITHOUT any break for comment lines/whatever. Otherwise, ONLY the last entry (or last set lines for multiple entries) will be effective. Keep this in mind while editing your init.ora now and in the future. (This rule applies for "event" lines as well).

And before everyone jumps on me for not using DIRECTORIES, this is an 8i database :)

> > AFAIK you can set the parameter as many times as you
> > like in your pfile?

-- 
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Disappointment is always inevitable; Discouragement is invariably optional

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l