|
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.
|
