V$TABLESPACE

Oracle 11gR1

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)

Note:

1.

select * from V$TABLESPACE;

TS#	NAME	INCLUDED_IN_DATABASE_BACKUP	BIGFILE	FLASHBACK_ON	ENCRYPT_IN_BACKUP
0	SYSTEM	YES	NO	YES	NULL
2	TEMP	NO	NO	YES	NULL
3	CWMLITE	YES	NO	YES	NULL
6	TOOLS	YES	NO	YES	NULL
7	USERS	YES	NO	YES	NULL

Oracle dynamic performance views