UTL_FILE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: UTL_FILE

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    Ihave specified in the parameter

    utl_file_dir=/ora4/oracle/download

    Every thing is going on fine.but when the number of files comes to 50 .it stops writing.

    what is the work around.

    Radhakrishnan.M

  2. #2
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    According to Oracle documentation, the maximum number of files you can have open at once is 50. The only workaround is to close some files before you try to open others.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width