UTL_FILE package can't write too large file?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: UTL_FILE package can't write too large file?

  1. #1
    Join Date
    Nov 2000
    Posts
    1

    Talking

    Hi!


    I was trying to export some data from database by UTL_FILE Package.
    Everything is fine when data amout is not large.
    But when data amout is larger, it seems will be cutted and can't be put into one file.
    In fact, I found the size of file won't be exceed 2100 bytes.

    I can't find any information about this.
    Is there are any constraint when Oracle doing file I/O?
    would you so kind to help me?

    Thanks a lot!




  2. #2
    Join Date
    Oct 2000
    Posts
    90
    UTL_FILE is a bit of a minefield, but you definately can get it to write files larger than 2100 bytes. There is a character limit, prior to Oracle 8.0, you cannot read or write a line of text with more than 1023 bytes. In Oracle 8.0 and above, you can specify a maximum line size of up to 32767 when you open a file. Maybe you need to split up what you are doing and also make sure you are doing FFLUSH

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