RE: Max data file size on NTFS partition

Thanks for replying Ed.
We did set disable AUTOEXTEND once we realized it was playing one of the "starring" roles in our problem. I opened TAR in Metalink and I'll post the answer when I get a response.

Thanks,
Ashley

-----Original Message-----
Sent: Wednesday, December 19, 2001 12:47 PM To: Multiple recipients of list ORACLE-L

Hi Ashley,

Sorry, don't know exact answer, but the problem doesn't always come from OS side. There are *Oracle*
limits on some platforms. It seems you use AUTOEXTEND=ON for your files. If so then you may
encountered some bugs when your files had extended through size limits. At least there were some bugs in the past. I prefer disabling this option in order to get more
control over db and add files when needed. All files are of equal size.

Regards,
Ed

> 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: Edward Shevtsov
  INET: ed_at_mb.ru

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: 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).