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:39:28 -0700
Message-ID: <F001.005AA688.20030604115956@fatcity.com>


It doesn't seem to be a problem on other platforms... Just when I stopped feeling like a neglected step child for running on Linux. Don't worry... Be happy... There's a workaround... Upgrade and buy more software...

D'ai jobu desu... er, eh, Ca ne fais rien.

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

This almost sounds like the problem that existed for Oracle 7.3 and the 2G threshold a couple of years ago...

J'ai une impression d'avoir déjà vu ceci.

: )

Patrice.

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

Steve - are you saying that there is a workaround by increasing the size of the file manually to something larger than 4G?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, June 04, 2003 1: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: Mercadante, Thomas F
  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: Boivin, Patrice J
  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:39:28 CDT

Original text of this message

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