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

Thread: UTL_FILE

  1. 11-16-2000, 01:35 PM #1
    omegamark
    omegamark is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 11-16-2000, 03:04 PM #2
    carp
    carp is offline Moderator
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width