RC_TABLESPACE

5.59 RC_TABLESPACE

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	Data Type	Description
`DB_KEY`	`NUMBER`	The primary key for the target database. Use this column to join with almost any other catalog view.
`DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database. Use this column to join with `RC_DATABASE_INCARNATION`.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`CON_ID`	`NUMBER`	The ID of the current container: 0: Rows containing data that pertain to the entire multitenant container database (CDB) or a traditional Oracle databases (non-CDBs) 1: Rows containing data that pertains only to the root n: Where n is the applicable container ID for the rows containing data
`PDB_NAME`	`VARCHAR2(30)`	The name of the pluggable database (PDB) in the recovery catalog.
`PDB_KEY`	`NUMBER`	The primary key for the PDB in the recovery catalog.
`PDBINC_KEY`	`NUMBER`	The primary key for the incarnation of the PDB.
`PLUGIN_CHANGE#`	`NUMBER`	SCN at which the foreign tablespace was transported into the database. A value of 0 indicates that this is not a foreign tablespace.
`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 data file).
`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 data file.
`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`.
`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`)