Is it possible that your COMPATIBLE parameter
is set to 9.0 rather than 9.2 ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminars
UK June / July
Australia July / August
http://www.jlcomp.demon.co.uk/seminar.html
Vladimir Begun wrote in message <3D062D81.6B105595_at_oracle.com>...
>CREATE DATABASE yourdbname
>...
>DATAFILE '...system01.dbf' SIZE xM REUSE AUTOEXTEND ON NEXT xK
>...
>...
>
>SQL> SELECT * FROM v$version;
>
>BANNER
>----------------------------------------------------------------
>Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
>PL/SQL Release 9.2.0.1.0 - Production
>CORE 9.2.0.1.0 Production
>TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
>NLSRTL Version 9.2.0.1.0 - Production
>
>SQL> SELECT tablespace_name, extent_management FROM dba_tablespaces;
>
>TABLESPACE_NAME EXTENT_MAN
>------------------------------ ----------
>SYSTEM DICTIONARY
>UNDOTBS1 LOCAL
>TEMP LOCAL
>CWMLITE LOCAL
>DRSYS LOCAL
>EXAMPLE LOCAL
>INDX LOCAL
>ODM LOCAL
>TOOLS LOCAL
>USERS LOCAL
>XDB LOCAL
>
Received on Tue Jun 11 2002 - 12:42:49 CDT
