Purpose
The V$OB_ENCRYPTED_TABLES view displays the encryption status of tables with encryption enabled.
Note
This view is introduced since OceanBase Database V4.0.0.
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 |