Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Utl_file limitation of 2 GB?

pattarSep 23 2008 — edited Sep 24 2008
Hello,

I have files which have more than 10 million records which needs to be written to flat file and saved off. I have a routine which uses UTL_FILE functionality to write the file out of Oracle 8i database. But, somehow the files stop at 2 GB limit? Where can I set this limit to write to more than 2GB file? OS does not have the 2GB limit. Is there a better way to extract the files without UTL_FILE?

Also, using the avg_row_len I have set the linesize but some columns which occupy about 256 bytes - how do I calculate the linesize for these columns?

Please help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2008
Added on Sep 23 2008
6 comments
431 views