Tablespace Issue - Urgent...

[iyyappan]

Dear Gurus,

Just now i have created one tablespace like

SQL> create tablespace fin_users
2 datafile '/proddb/oracle/findata/find01.dbf' size 400m
3 extent management local autoallocate;

After creating my tablespace i use following command

select tablespace_name,extent_management,allocation_type from
dba_tablespaces;

FIN_USERS LOCAL SYSTEM


Can u please explain ALLOCATION_TYPE - SYSTEM means what?

I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.

Please explain ALLOCATION_TYPE - SYSTEM means what?

Thanks in advance,
Iyyappan.M

[Sameer]

Originally posted by iyyappan
Can u please explain ALLOCATION_TYPE - SYSTEM means what?

I Know where AUTOALLOCATE causes Oracle to automatically manage extent size.

Please explain ALLOCATION_TYPE - SYSTEM means what?

When Oracle manages extent allocation when we define as 'AUTOALLOCATE', allocation_type column shows 'SYSTEM'. If we define our own UNIFORM SIZE then the column shows as 'UNIFORM', if the tablespace is of type DICTIONARY, then column contains 'USER'

Sameer

[julian]

Check Note:93771.1 on Metalink.