Static Data Dictionary Views, 246 of 452

DBA_TABLESPACES

DBA_TABLESPACES describes all tablespaces in the database.

USER_TABLESPACES describes all 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`	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