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

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

Go to previous page
Previous
Go to next page
Next
View PDF

V$TABLESPACE

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