Re: Max size for UTL_FILE_DIR parameter

I don't believe there is a limit. Just keep adding directories. I have long since past the 512 byte mark that v$parameter seems to suggest is the limit because of the varchar2(512) datatype of the "value" field.

If you want to see all the directories, use v$parameter2 rather than v$parameter. They will be listed one directory per line.

select value from v$parameter2 where name = 'utl_file_dir';

Frank Hubeny

Luis Santos wrote:

> Hi!
>
> Please answer me in a nutshell: Which is the max size for UTL_FILE_DIR
> parameter?
>
> My UTL_FILE_DIR is increasing everyday, with aditions of new
> directories. And I don´t want to set it as "*".
>
> Best regards,
> Luis Santos
Received on Wed Jul 18 2001 - 01:34:43 CDT