TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Tablespace name |
INITIAL_EXTENT |
NUMBER |
|
Default initial extent size |
NEXT_EXTENT |
NUMBER |
|
Default incremental extent size |
MIN_EXTENTS |
NUMBER |
NOT NULL |
Default minimum number of extents |
MAX_EXTENTS |
NUMBER |
NOT NULL |
Default maximum number of extents |
PCT_INCREASE |
NUMBER |
NOT NULL |
Default percent increase for extent size |
MIN_EXTLEN |
NUMBER |
|
Minimum extent size for the tablespace |
STATUS |
VARCHAR2(9) |
|
Tablespace status: ONLINE , OFFLINE , or READ ONLY |
CONTENTS |
VARCHAR2(9) |
|
Tablespace contents: PERMANENT , or TEMPORARY |
LOGGING |
VARCHAR2(9) |
|
Default logging attribute |
EXTENT_MANAGEMENT |
VARCHAR2(10) |
|
Extent management tracking: DICTIONARY or LOCAL |
ALLOCATION_TYPE |
VARCHAR2(9) |
|
Type of extent allocation in effect for this tablespace |
PLUGGED_IN |
VARCHAR2(3) |
|
YES - the tablespace is plugged in; NO - it is not plugged in |