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 a smallfile tablespace (NO) |
FLASHBACK_ON |
VARCHAR2(3) |
Indicates whether the tablespace participates in FLASHBACK DATABASE operations (YES) or not (NO) |
ENCRYPT_IN_BACKUP |
VARCHAR2(3) |
Indicates whether encryption is turned ON or off at the tablespace level:
-
ON - Encryption is turned ON at the tablespace level
-
OFF - Encryption is turned OFF at the tablespace level
-
NULL - Encryption is neither explicitly turned on nor off at the tablespace level (default or when cleared)
|
