Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


V$TABLESPACE 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 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)