You can have autoextend on, but you've got to tell Oracle how much & by = how much. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Fahd Mirza [mailto:fahd-m@xxxxxxxxxxx] Sent: Wednesday, April 28, 2004 1:16 AM To: oracle-l@xxxxxxxxxxxxx Subject: AutoExtend / Locally Managed Hi all, 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. 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------