V$TABLESPACE displays tablespace information from the control file.
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
Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)
Indicates whether the tablespace participates in FLASHBACK DATABASE operations (YES) or not (NO)
Indicates whether encryption is turned ON or off at the tablespace level:
ON - Encryption is turned ON at the tablespace level
OFF - Encryption is turned OFF at the tablespace level
NULL - Encryption is neither explicitly turned on nor off at the tablespace level (default or when cleared)
The ID of the container to which the data pertains. Possible values include:
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data