Tuesday, September 22, 2009

V$TABLESPACE


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)

Last updated: Tuesday, September 22, 2009

Oracle data dictionary views


No comments:

Post a Comment