Ora-25143................

[nkumarin001]

I have created two tablespaces:-
Tbsnav11 is correct
Tbsnav12 is wrong

First

SQL> create tablespace Tbsnav11
2 datafile 'C:\oracle\oradata\Chandu\dbfnav11.dbf' size 3m
3 default storage
4 (
5 initial 10k
6 next 20k
7 pctincrease 50
8 );

Tablespace created.

SQL> select extent_management from dba_tablespaces where tablespace_name='TBSNAV11';

EXTENT_MAN
----------
LOCAL


Second:-

SQL> create tablespace Tbsnav12
2 datafile 'C:\oracle\oradata\Chandu\dbfnav12.dbf' size 3m
3 extent management local
4 default storage
5 (
6 initial 10k
7 next 20k
8 pctincrease 50
9 );
create tablespace tbsnav12
*
ERROR at line 1:
ORA-25143: default storage clause is not compatible with allocation policy



While browsing I saw that in Locally Managed Tablespace , you cannot specify DEFAULT STORAGE, MINIMUM EXTENT or TEMPORARY.

Question:-
In oracle9i even though if we don’t specify extent management it is LOCAL then while creating tablespace Tbsnav11 why it is not giving error.
And while creating tablespace Tbsnav12 why it is giving error.