DBA_TABLESPACES
describes all tablespaces in the database.
USER_TABLESPACES
describes the tablespaces accessible to the current user. This view does not display the PLUGGED_IN
column.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the tablespace |
BLOCK_SIZE |
NUMBER |
NOT NULL |
Tablespace block size |
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 |
Default maximum number of extents | |
PCT_INCREASE |
NUMBER |
Default percent increase for extent size | |
MIN_EXTLEN |
NUMBER |
Minimum extent size for this tablespace | |
STATUS |
VARCHAR2(9) |
Tablespace status:
|
|
CONTENTS |
VARCHAR2(9) |
Tablespace contents:
|
|
LOGGING |
VARCHAR2(9) |
Default logging attribute:
|
|
FORCE_LOGGING |
VARCHAR2(3) |
Indicates whether the tablespace is under force logging mode (YES ) or not (NO ) |
|
EXTENT_MANAGEMENT |
VARCHAR2(10) |
Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY ) or locally managed (LOCAL ) |
|
ALLOCATION_TYPE |
VARCHAR2(9) |
Type of extent allocation in effect for the tablespace:
|
|
PLUGGED_IN |
VARCHAR2(3) |
Indicates whether the tablespace is plugged in (YES ) or not (NO ) |
|
SEGMENT_SPACE_MANAGEMENT |
VARCHAR2(6) |
Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL ) or bitmaps (AUTO ) |
|
DEF_TAB_COMPRESSION |
VARCHAR2(8) |
Indicates whether default table compression is enabled (ENABLED ) or not (DISABLED )
Note: Enabling default table compression indicates that all tables in the tablespace will be created with table compression enabled unless otherwise specified. |
|
RETENTION |
VARCHAR2(11) |
Undo tablespace retention:
|
|
BIGFILE |
VARCHAR2(3) |
Indicates whether the tablespace is a bigfile tablespace (YES ) or a smallfile tablespace (NO ) |
See Also:
"USER_TABLESPACES"