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

FWIW, we use 2048m here.

--Walt (who feels obligated to make some posts since Steve's off today) Weaver   Bozeman, Montana

> -----Original Message-----
> From: Jared Still [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 08, 2003 11:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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).
>

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