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).
Received on Mon Jul 07 2003 - 20:57:35 CDT
