Re: utl_file_dir

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

Stefan

On 9/28/06, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
>
> Edwin
>
> > But my question is how many number of files can mentioned for
> > utl_file_dir and not the size of each file.
> > is there limit for number of files?(not size)
> > is it unlimited number of files?(not size)
>
> You asked for the number of directories. Now, since the limit of the
> number of character you can put in that parameter is 512... If your
> paths are quite long, you could put only 2 or 3... If your paths are
> very short, you could put 100 or 200... I.e. there is no limit on the
> number of directories.
>
>
> HTH
> Chris
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l