This view lists all tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations. It corresponds to the V$TABLESPACE view. The current value is shown for tablespace attributes.
The primary key for the target database. Use this column to join with almost any other catalog view.
The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION.
The DB_NAME of the database incarnation to which this record belongs.
The tablespace ID in the target database. The TS# may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
The creation SCN (from the first datafile).
The creation time of the tablespace. NULL for offline tablespaces after creating the control file.
The SCN recorded when the tablespace was dropped. If a new tablespace with the same TS# is discovered, then the DROP_CHANGE# is set to CREATION_CHANGE# for the tablespace; otherwise, the value is set to RC_CHECKPOINT.CKP_SCN.
The date when the tablespace was dropped.
Indicates whether this tablespace is included in whole database backups: YES or NO. The YES value occurs only if CONFIGURE EXCLUDE was run on the tablespace that owns this datafile.
Indicates whether this tablespace is a tablespace created with the BIGFILE option.
YES if tablespace is a locally managed temporary tablespace. Otherwise, NO.
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)