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 container to which the data pertains. Possible values include:

  • 0: Rows containing data that pertain to the entire multitenant container database (CDB)

  • 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)