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

Nevermind, a search on "2gb" yielded Note 112011.1, which seems to explain it all. Oh well, one more item for my "to do" list.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 04, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L

Steve - Is there a Metalink note on this? What would a person search for?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L

See my note: "There is no such O/S file size limit."

We have datafiles > 2GB which work just fine. The problem is with autoextending datafiles that extend from <2GB to >2GB. It's not a Linux limitation but a limitation imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have this problem. And my peeve is that it took OWS 4 days to "discover" this "limit."

Still peeved, :-)
Steve

-----Original Message-----
Sent: Wednesday, June 04, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L

I think it is the limitation of Linux, not Oracle. Use LVM and don't worry about file size limit. :-)

JP
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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: sorr_at_rightnow.com
>
> 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: 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.net
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

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: 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.net
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

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: 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.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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