Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Just curious how you arrived at the 1900 meg number.

Why not use 2000m?

Oracle defines gigabytes in binary, not decimal as drive mfg's do, so 2000m would be fine.

Not a criticism, just wondering.

Jared

On Sunday 08 June 2003 09:29, Yechiel Adar wrote:
> We have been hit by a bug in autoextend that corrupted a database (8.1.6)
> on NT.
> It seems that the bug was exported to Linux as well.
>
> We now use all datafiles with autoextend up to 1900 MB.
> We also define a second datafile with 200MB initial and autoextend to 1900
> MB.
> Whenever the last datafile starts to grow we define a new one with 200MB
> etc.
>
> Seems to work so far.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Wednesday, June 04, 2003 5:40 PM
>
> > I've just been informed that there is a 2GB datafile size limit with
>
> Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
> in excess of this for some time and they work just fine. The problem occurs
> when the autoextend "feature" reaches the 2GB threshhold. Of course, Oracle
> didn't tell me this until after about 4 days of back and forth testing for
> them. (There is no such O/S file size limit.) I've reviewed the Linux
> release notes, the Linux install guide, the Linux admin guide and the
> contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
> the documentation. Did I miss it? Can anyone find any such published
> limitation in the docs? Is this a secret?
>
> > Peeved at Oracle... AGAIN,
> > Steve Orr
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Orr, Steve
> > 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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).