Re: Max data file size on NTFS partition

I don't have any problems with 5GB files (5000064K to be precise, LMT tablespace) on 8.1.5, NT.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 19, 2001 2:00 PM

> I have had problems creating files above the 4G limit with NTFS. Even
files
> above 2GB were sometimes difficult.
>
> Thank You
>
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
>
> -----Original Message-----
> Sent: Wednesday, December 19, 2001 11:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Max data file size on NTFS partition
>
> Hello to all my most favorite DBAs...
>
> Yes, believe it or not, I checked the archives, Metalink and Oracle
> documentation, but all come up with a different answer to my question.
> What is the max data file size for an NTFS partition on Advanced Server?
>
>
> I'm running Oracle 8i Release 2 8.1.6 Standard...soon to be Enterprise.
> The Oracle 8i documentation states 80EB on an NTFS partition, but I've
> seen reference to 4GB limits everywhere else. Quite different, wouldn't
> you say?
>
> The reason I'm asking the question is we keep running into errors. The
> most common were, write/open error block X invalid parameter passed and
> unable to extend file X.
>
> I would appreciate any help. I'm new, so please be gentle...
>
> Ashley
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gilbert, Ashley
> INET: Ashley.Gilbert_at_eadvancemed.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).