From oracle-l-bounce@freelists.org Wed Apr 28 06:42:07 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3SBfgR10907 for ; Wed, 28 Apr 2004 06:41:52 -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 i3SBfW610872 for ; Wed, 28 Apr 2004 06:41:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9DA7F72CAE6; Wed, 28 Apr 2004 06:33:31 -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 15577-72; Wed, 28 Apr 2004 06:33:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1E4872C994; Wed, 28 Apr 2004 06:33:30 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 28 Apr 2004 06:32:19 -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 E8A7B72CA40 for ; Wed, 28 Apr 2004 06:32:18 -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 15103-82 for ; Wed, 28 Apr 2004 06:32:18 -0500 (EST) Received: from galottery.org (mail.galottery.org [206.98.139.209]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6786372CAB5 for ; Wed, 28 Apr 2004 06:32:18 -0500 (EST) Received: from CONNECT-MTA by galottery.org with Novell_GroupWise; Wed, 28 Apr 2004 07:44:48 -0400 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.1 Date: Wed, 28 Apr 2004 07:44:30 -0400 From: "Ron Rogers" To: Subject: Re: AutoExtend / Locally Managed Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 3921 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: RROGERS@galottery.org Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Fahd, Autoextend does work in 8.1.7.4 and 9.2.0.5 example: CREATE TABLESPACE fixed_data DATAFILE '/data5/lnxdb/fixedd01.dbf' SIZE 2 M AUTOEXTEND ON NEXT 100 k EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100 k; Ron >>> fahd-m@aero.com.pk 04/28/2004 1:16:06 AM >>> Hi all, Why can't we put " autoextend on" in the creation of locally managed tablespaces? I wrote like this 1-create tablespace tbs1 '' size 10M 2-autoextend on 3-extent management local uniform size 128K; 4-and it is giving me error on line 2. Please give some lights. regards, Fahd ---------------------------------------------------------------- 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 -----------------------------------------------------------------