This view displays tablespace information from the control file.
Column | Datatype | Description |
---|---|---|
TS# |
NUMBER |
Tablespace number |
NAME |
VARCHAR2(30) |
Tablespace name |
INCLUDED_IN_DATABASE_BACKUP |
VARCHAR2(3) |
Indicates whether the tablespace is included in full database backups using the BACKUP DATABASE RMAN command (YES ) or not (NO ). NO only if the CONFIGURE EXCLUDE RMAN command was used for this tablespace. |
BIGFILE |
VARCHAR2(3) |
Indicates whether the tablespace is a bigfile tablespace (YES ) or not (NO ) |
FLASHBACK_ON |
VARCHAR2(3) |
Indicates whether the tablespace participates in FLASHBACK DATABASE operations (YES ) or not (NO ) |
ENCRYPT_IN_BACKUP |
VARCHAR2(3) |
Possible values are:
|