V$TABLESPACE

This view displays tablespace information from the control file.

Column	Datatype	Description
`TS#`	`NUMBER`	Tablespace number
`NAME`	`VARCHAR2(30)`	Tablespace name
`INCLUDED_IN_DATABASE_BACKUP`	`VARCHAR2(3)`	Indicates whether the tablespace is included in full database backups using the `BACKUP DATABASE` RMAN command (`YES`) or not (`NO`). `NO` only if the `CONFIGURE EXCLUDE` RMAN command was used for this tablespace.
`BIGFILE`	`VARCHAR2(3)`	Indicates whether the tablespace is a bigfile tablespace (`YES`) or not (`NO`)
`FLASHBACK_ON`	`VARCHAR2(3)`	Indicates whether the tablespace participates in `FLASHBACK DATABASE` operations (`YES`) or not (`NO`)
`ENCRYPT_IN_BACKUP`	`VARCHAR2(3)`	Possible values are: `ON` - encryption is turned ON at tablespace level `OFF` - encryption is turned OFF at tablespace level `NULL` - encryption is neither explicitly turned on or off at tablespace level (default or when CLEARED).