AFAIK you can set the parameter as many times as you like in your pfile?
> 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 -- //www.freelists.org/webpage/oracle-l