Recovery Catalog Views, 25 of 25

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 Datatype NULL Description

DB_KEY

NUMBER

NOT NULL

The primary key for the target database. Use this column to form a join with almost any other catalog view.

DBINC_KEY

NUMBER

NOT NULL

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)

NOT NULL

The DB_NAME of the database incarnation to which this record belongs.

TS#

NUMBER

NOT NULL

The tablespace identifier 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)

NOT NULL

The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.

CREATION_CHANGE#

NUMBER

NOT NULL

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.

Column	Datatype	NULL	Description
DB_KEY	NUMBER	NOT NULL	The primary key for the target database. Use this column to form a join with almost any other catalog view.
DBINC_KEY	NUMBER	NOT NULL	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)	NOT NULL	The DB_NAME of the database incarnation to which this record belongs.
TS#	NUMBER	NOT NULL	The tablespace identifier 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)	NOT NULL	The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
CREATION_CHANGE#	NUMBER	NOT NULL	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.