Re: utl_file_dir

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: Christian.Antognini@xxxxxxxxxxxx
  • Date: Thu, 28 Sep 2006 12:21:35 +0200

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


On 9/28/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote:


> 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 -- //

Other related posts: