Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the encryption status of tables with encryption enabled in the current tenant. The sys tenant does not support encryption.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| TABLE_NAME | varchar(256) | NO | The name of the table. |
| TABLESPACE_ID | bigint(20) | NO | The ID of the tablespace. |
| ENCRYPTIONALG | varchar(30) | NO | The name of the encryption algorithm. Valid values: |
| ENCRYPTED | varchar(3) | NO | Indicates whether the encryption is completed. Valid values: |
| ENCRYPTEDKEY | varchar(33) | NO | The encryption key encrypted by the master key. |
| MASTERKEYID | bigint(20) unsigned | NO | The ID of the master key. |
| BLOCKS_ENCRYPTED | decimal(20,0) | NO | The number of encrypted macroblocks. |
| BLOCKS_DECRYPTED | decimal(21,0) | NO | The number of macroblocks that are not encrypted. |
| STATUS | varchar(10) | The encryption status. Valid values: NORMAL: normalENCRYPTING: being encryptedDECRYPTING: being decrypted |
|
| CON_ID | bigint(20) | NO | The ID of the tenant. |
References
For more information about data transparent encryption, see Data transparent encryption.