From sorr@rightnow.com Thu, 05 Jun 2003 05:15:58 -0700 From: "Orr, Steve" Date: Thu, 05 Jun 2003 05:15:58 -0700 Subject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ??? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yeah, now I call it the "outta-extend" feature. :-) -----Original Message----- Sent: Wednesday, June 04, 2003 12:28 PM To: '[EMAIL PROTECTED]' Cc: Orr, Steve nice. either way, you're screwed into doing more work than you had planned. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Wednesday, June 04, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Well... datafiles > 2GB seem to work okay but since Oracle is being a weenie about supporting them altogether I'm choosing not to. One of the first hoops OWS had me jump thru in the wild goose chase was to manually extend datafiles via maxsize without using "unlimited." Eventually the only workarounds suggested by Oracle were: 1) turn off autoextend and manually add datafiles; 2) upgrade to 9i. -----Original Message----- Sent: Wednesday, June 04, 2003 12: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: 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: 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).