Hi Ron Fahd simply forgot the "DATAFILE" keyword in his example. Happens sometimes ... Cheers Richard ----- Original Message ----- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, April 28, 2004 9:44 PM Subject: 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; ---------------------------------------------------------------- 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 -----------------------------------------------------------------