From oracle-l-bounce@freelists.org Thu Jan 20 15:35:15 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0KLZFlD021510 for ; Thu, 20 Jan 2005 15:35:15 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0KLZFxu021506 for ; Thu, 20 Jan 2005 15:35:15 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3167D72C26E; Thu, 20 Jan 2005 15:34:34 -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 19737-71; Thu, 20 Jan 2005 15:34:34 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A68E72CA1D; Thu, 20 Jan 2005 15:32:05 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: RE: Locally Managed Tablespaces Date: Thu, 20 Jan 2005 12:16:23 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Locally Managed Tablespaces Thread-Index: AcT/JzB3vEMuK+0USUicy8i8RFXjogAAaxOwAAC73OA= From: "Jacques Kilchoer" To: , X-OriginalArrivalTime: 20 Jan 2005 20:16:23.0780 (UTC) FILETIME=[E9B4CA40:01C4FF2C] Content-Transfer-Encoding: 8bit X-archive-position: 15035 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jacques.Kilchoer@quest.com Precedence: normal Reply-To: Jacques.Kilchoer@quest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com If you have a locally managed tablespace, you don't need to bother with specifying the INITIAL, NEXT, MINEXTENTS, PCTINCREASE storage parameters. You can specify them, and Oracle will initially allocate as many extents as it needs to satisfy the storage parameters, but there's no advantage in doing so unless you want to make sure that your table has space "pre-reserved." e.g. locally managed tablespace uniform extent size 1M create table x (...) storage (initial 10M next 20M minextents 5) You have asked for 5 extents, 1 of 10M and 4 of 20M for a total of 90M. Your table will be created with 90 1M extents. After that Oracle will allocate 1M extents as needed - the NEXT parameter will be ignored from now on. -----Original Message----- Smith, Ron L. We are upgrading an application that uses an external database to set=20 initial table create parameters. =20 I would like to use Locally Manages tablespaces and Uniform extent=20 sizes, instead of the table create parameters.=20 My question is, will Locally Manages tablespaces cause Oracle to ignore=20 the table create parameters? (I hope)=20 And, if I have some tables that are empty, and some that have a million=20 rows, what do I use for an initial extent size?=20 Do I allocate them all small and let the large tables go into extents?=20 I don't have the luxury of putting large tables in a separate=20 tablespace. Everything is in one schema and one tablespace.=20 -- http://www.freelists.org/webpage/oracle-l