Function
V$ENCRYPTED_TABLESPACES displays the encryption status of tablespaces with encryption enabled.
Field description
| Name | Type | Nullable | Description |
|---|---|---|---|
| TABLESPACE_ID | NUMBER(38) | NO | The ID of the tablespace. |
| ENCRYPTIONALG | VARCHAR2(30) | NO | The name of the encryption algorithm. Values: * AES-128 * AES-192 * AES-256 * SM4 |
| ENCRYPTED | VARCHAR2(3) | NO | Whether the encryption is completed. Values: * YES * NO |
| ENCRYPTEDKEY | VARCHAR2(32) | NO | The encryption key encrypted by the master key. |
| MASTERKEYID | NUMBER(38) | NO | The ID of the master key. |
| BLOCKS_ENCRYPTED | NUMBER | NO | The number of encrypted macro blocks. |
| BLOCKS_DECRYPTED | NUMBER | NO | The number of macro blocks that are not encrypted. |
| STATUS | VARCHAR2(10) | NO | The encryption status. Values: * NORMAL: normal * ENCRYPTING: being encrypted * DECRYPTING: being decrypted |