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
Re: Tablespace Issue - Urgent...
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
Re: Tablespace Issue - Urgent...
Check Note:93771.1 on Metalink.