Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

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
PDF · Mobi · ePub


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:
  • ON - encryption is turned ON at tablespace level

  • OFF - encryption is turned OFF at tablespace level

  • NULL - encryption is neither explicitly turned on or off at tablespace level (default or when CLEARED).