Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???

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

From: Orr, Steve <sorr_at_rightnow.com>
Date: Thu, 05 Jun 2003 05:35:35 -0700
Message-ID: <F001.005AA653.20030604115441@fatcity.com>


As per Branimer's previous post, try searching under "dirty little secrets." :-)

-----Original Message-----
Sent: Wednesday, June 04, 2003 1: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.
[EMAIL PROTECTED] -----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" <[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: Jan Pruner
  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: 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: DENNIS WILLIAMS
  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: 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).
Received on Thu Jun 05 2003 - 07:35:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US