Adar, >From what I understand and have seen it's not just at 4GB - it's EVERY 4GB. So for example if your database extends from 3.8GB - 4.2GB it fail just as it will extending from 7.8GB-8.2GB or 11.8GB - 12.2GB (for example).
It certainly DOESN'T mean that you can't use files larger than 4GB! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -----Original Message----- Sent: 19 August 2002 19:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH ---------------------------------------------------------------------- Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 1:48 PM > Where can I find the more information on this boundary? Is there any such > limit for Oracle/Linux? > TIA! > > Aleem > > -----Original Message----- > Sent: Thursday, August 15, 2002 7:44 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Data Warehouse on Windows > > Don't forget the Oracle/Windows 4GB boundary corruption problem! > > Lewis Bishop > --- > Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant > Phone - 020 8298 3418 > Mobile - 07950 380857 > Email - [EMAIL PROTECTED] > > > -----Original Message----- > Sent: 15 August 2002 14:58 > To: Multiple recipients of list ORACLE-L > > This header confirms that this email message has been swept for the > presence of computer viruses. > > Corporate IT > THE WOOLWICH > ---------------------------------------------------------------------- > > Hi, > I was asked to give some hint for the hardware for a data warheouse running > on Win 2k and holding about 20-40 GB data. > Project will have about 40 small and 7-8 large tables. Users <20. Probably > long running queries. > Which hardware would you use? How many processors? Which disks? > The os-system is set and cannot be Unix/Linux according to management > decision. > Any tips/recommendations appreciated > Antje Sackwitz > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sackwitz, Antje > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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). > > > The information, attachments and opinions contained in this message are > those of its author only and do not necessarily represent those of The > Woolwich and or any other members of the Barclays Group and are intended > solely for the use of the individual or entity to whom they are addressed. > The sender may not be authorised to give financial advice, and nothing in > this message should be construed as offering such advice. > > The message may contain privileged and confidential information and you may > not copy, distribute or take any action in reliance on it. If you have > received this email in error please notify the Information Security Manager > at [EMAIL PROTECTED] > > Replies to this email may be monitored for operational or business reasons. > > Woolwich plc. Registered in England Number : 3295699. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bishop Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com > -- > Author: Abdul Aleem > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). The information, attachments and opinions contained in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
