From oracle-l-bounce@freelists.org Tue Jul 20 08:08:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6KD8Y903783 for ; Tue, 20 Jul 2004 08:08:44 -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 i6KD8O603737 for ; Tue, 20 Jul 2004 08:08:34 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D490272C9F1; Tue, 20 Jul 2004 07:47:51 -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 03822-22; Tue, 20 Jul 2004 07:47:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD58D72C9B9; Tue, 20 Jul 2004 07:47:50 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Jul 2004 07:46:24 -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 A3D1E72C8D7 for ; Tue, 20 Jul 2004 07:46:23 -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 03519-13 for ; Tue, 20 Jul 2004 07:46:23 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3D74C72C5F5 for ; Tue, 20 Jul 2004 07:46:23 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 20 Jul 2004 13:16:30 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00A44@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Maximum number of partitions? Date: Tue, 20 Jul 2004 08:06:55 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5478 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Eric My experience is that you'll find you can create a lot more partitions than you can manage. Carefully consider your management strategy. Dennis Williams DBA Lifetouch, Inc. Does believing you're the last sane man on the planet make you crazy? Del Spooner in I Robot, played by Will Smith -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Justin Cave Sent: Monday, July 19, 2004 11:29 PM To: oracle-l@freelists.org Subject: RE: Maximum number of partitions? According to the Oracle Reference http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44.htm #288033, 64k - 1 Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Yen, Eric Sent: Monday, July 19, 2004 10:16 PM To: oracle-l@freelists.org Subject: Maximum number of partitions? We are about to List Partition a table that has 78 million rows. Has anyone heard if there is a maximum number of partitions that a table can have in Oracle 9.2.0.4. ? Please site source if possible. Eric Yen ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------