From oracle-l-bounce@freelists.org Tue Jun 29 12:40:50 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5THeZW15886 for ; Tue, 29 Jun 2004 12:40:45 -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 i5THeE615837 for ; Tue, 29 Jun 2004 12:40:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53F6B72C99F; Tue, 29 Jun 2004 12:22:48 -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 16909-24; Tue, 29 Jun 2004 12:22:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5B07B72CA7A; Tue, 29 Jun 2004 12:22:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 29 Jun 2004 12:21:20 -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 3E73D72C653 for ; Tue, 29 Jun 2004 12:21:19 -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 16057-43 for ; Tue, 29 Jun 2004 12:21:19 -0500 (EST) Received: from web50004.mail.yahoo.com (web50004.mail.yahoo.com [206.190.38.19]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id BC7D572C66C for ; Tue, 29 Jun 2004 12:21:17 -0500 (EST) Message-ID: <20040629174350.57349.qmail@web50004.mail.yahoo.com> Received: from [192.234.2.50] by web50004.mail.yahoo.com via HTTP; Tue, 29 Jun 2004 10:43:50 PDT Date: Tue, 29 Jun 2004 10:43:50 -0700 (PDT) From: Raj Jamadagni Subject: Re: Max datafile size in AIX5.2L To: oracle-l@freelists.org In-Reply-To: <20040629043419.21485.qmail@webmail31.rediffmail.com> 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: 3969 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 We have used 16GB at times ... but we use sushi files (raw not cooked) Raj --- Prem Khanna J wrote: > Hi All, > The env. is oracle 9.2.0.4 & AIX 5.2L (64 bit) > > What is the safe limit for maximum datafile size ? > I see lot of articles about 2GB limitation. > > Any advise would be greatly helpful. > > Thanks. > Prem. ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! 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 -----------------------------------------------------------------