V$ENCRYPTED_TABLESPACES

V$ENCRYPTED_TABLESPACES displays information about the tablespaces that are encrypted.

Column Datatype Description
TS# NUMBER Tablespace number
ENCRYPTIONALG VARCHAR2(7) Encryption algorithm:

  • NONE

  • 3DES168

  • AES128

  • AES192

  • AES256
ENCRYPTEDTS VARCHAR2(3) Indicates whether the tablespace is encrypted (YES) or not (NO)