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'