From oracle-l-bounce@freelists.org Wed Jun 30 07:07:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5UC77D22739 for ; Wed, 30 Jun 2004 07:07:17 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5UC6v622680 for ; Wed, 30 Jun 2004 07:07:07 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2A75772CA30; Wed, 30 Jun 2004 06:49:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28133-32; Wed, 30 Jun 2004 06:49:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8563E72C876; Wed, 30 Jun 2004 06:49:21 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 30 Jun 2004 06:47:49 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 28A5772C138 for ; Wed, 30 Jun 2004 06:47:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26873-60 for ; Wed, 30 Jun 2004 06:47:48 -0500 (EST) Received: from web50008.mail.yahoo.com (web50008.mail.yahoo.com [206.190.38.23]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id C0CA172C110 for ; Wed, 30 Jun 2004 06:47:48 -0500 (EST) Message-ID: <20040630121028.60217.qmail@web50008.mail.yahoo.com> Received: from [192.234.2.50] by web50008.mail.yahoo.com via HTTP; Wed, 30 Jun 2004 05:10:28 PDT Date: Wed, 30 Jun 2004 05:10:28 -0700 (PDT) From: Raj Jamadagni Subject: RE: Max datafile size in AIX5.2L To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4060 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Ron, It's probably OS, usually size related errors are returned by OS, and mereyl transmitted to the program by Oracle. The original 2GB limitation was OS and hence enforced by Oracle. Raj --- Ron Rogers wrote: > Not related to AIX5, but I was building a learning 10g database on > RedHat AS 2.1u3 and accepted the defaults for the UNDO retention time. > I started loading 2 years worth of date sensitive data into a > partitioned table and the UNDOTBS grew to 6 gig and filled the disk. > Normally there was a 2 gig limit on the datafile sizes and this > supprised me when the disk filled. Perhaps Oracle has matured more than > we thought. > Ron ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------