You can have autoextend - but it's a datafile property not a property of = the tablespace anyway, syntax that works is (for example): create tablespace SM_IND_LARGE datafile=20 'd:\oradata\%oracle_sid%\SM_ind_large_01.dbf' size 128M reuse autoextend = on next 64M maxsize 2048M, 'f:\oradata\%oracle_sid%\SM_ind_large_02.dbf' size 128M reuse autoextend = on next 64M maxsize 2048M extent management local uniform size 16M; HTH, Bruce Reardon -----Original Message----- [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Fahd Mirza Sent: Wednesday, 28 April 2004 3:16 PM Subject: AutoExtend / Locally Managed Why can't we put " autoextend on" in the creation of locally managed = tablespaces? I wrote like this=20 1-create tablespace tbs1 '<file_path>' size 10M=20 2-autoextend on 3-extent management local uniform size 128K; 4-and it is giving me error on line 2. Fahd ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------