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.
| Column | Datatype | Description |
|---|---|---|
DB_KEY |
NUMBER |
The primary key for the target database. Use this column to form a join with almost any other catalog view. |
DBINC_KEY |
NUMBER |
The primary key for the incarnation of the target database. Use this column to form a join with RC_DATABASE_INCARNATION. |
DB_NAME |
VARCHAR2(8) |
The DB_NAME of the database incarnation to which this record belongs. |
TS# |
NUMBER |
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. |
NAME |
VARCHAR2(30) |
The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created. |
CREATION_CHANGE# |
NUMBER |
The creation SCN (from the first datafile). |
CREATION_TIME |
DATE |
The creation time of the tablespace. NULL for offline tablespaces after creating the control file. |
DROP_CHANGE# |
NUMBER |
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. |
DROP_TIME |
DATE |
The date when the tablespace was dropped. |
INCLUDED_IN_DATABASE_BACKUP |
VARCHAR2(3) |
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. |
BIGFILE |
VARCHAR2(3) |
Indicates whether this tablespace is a tablespace created with the BIGFILE option. |
TEMPORARY |
VARCHAR2(3) |
YES if tablespace is a locally managed temporary tablespace. Otherwise, NO. |