Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: AutoExtend / Locally Managed

Re: AutoExtend / Locally Managed

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 28 Apr 2004 07:44:30 -0400
Message-Id: <s08f60f0.024@galottery.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_at_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 '<file_path>' 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_at_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_at_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
-----------------------------------------------------------------
Received on Wed Apr 28 2004 - 06:42:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US