Ferenc, From what (little) I know of Win2K, the file size is only limited by the Volume Size (max vol size is 2TB). However, NTFS5 allows Disk Quotas. You may be running into quota limitations. Check under Properties dialog box for the Volume in question. There is a Quota tab.... and then.. happy drilling... ;)
Cheers! - Kirti --- Ferenc Mantfeld <[EMAIL PROTECTED]> wrote: > Hi All > > We have a process that is trying to create a huge flat file for a marketing export > on a windows > 2000 server host, and the file size seems to be constraining us. If I put a > constraint (where > clause) on the result set, it generates fine, but without it, I think I am exceeding > some > maximum file size. This is NTFS5, and the only thing I have found on the Microsquish > web site > knowledge base (after 2 hours of digging) is that the NFTS volumes are created with > a default > cluster size of 4096 bytes. I am not sure if this places a limit on the maximum file > size and > what other repercussions there are to this. > > Am I an the right track ? Anyone care to enlighten me to the wondrous (sic) workings > of > Microsquish Windows 2000 server ? > > Thanks. > > Ferenc Mantfeld > Dreaming costs you nothing. Not dreaming costs you everything. __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
