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

ENCRYPTEDKEY

RAW(32)

Encrypted version of the tablespace key for the encrypted tablespace

MASTERKEYID

RAW(16)

ID of the master key that was used to encrypt the tablespace key

BLOCKS_ENCRYPTED

NUMBER

Number of tablespace blocks that have been encrypted during the lifetime of this instance

BLOCKS_DECRYPTED

NUMBER

Number of tablespace blocks that have been decrypted during the lifetime of this instance

KEY_VERSION

NUMBER

Every encrypt/decrypt/rekey of a tablespace adds a carnation/version of the tablespace key, and the key version is incremented. A decrypted tablespace could still have a none-zero key version. In certain scenarios, however, the tablespace key version might reset to 0; for example, when a tablespace or a pluggable database (PDB) is plugged into a foreign database, or if the control file is recreated.

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

STATUS

VARCHAR2(10)

Shows the status of a tablespace. Possible values:

  • NORMAL: Used when the tablespace is not in one of the other statuses.

  • REKEYING: Used when a rekey operation is taking place

  • ENCRYPTING: Used when an encrypt operation is taking place

  • DECRYPTING: Used when a decrypt operation is taking place

  • UNKNOWN: Used when the database is mounted but not open (before the datafile is online and the key is known to the database)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

"V$DATABASE_KEY_INFO"