Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: AutoExtend / Locally Managed
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.
-- 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
![]() |
![]() |