Tablespace Issue - Urgent...

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

Quote:

---

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

Check Note:93771.1 on Metalink.