Oracle 视图 V$ENCRYPTED_TABLESPACES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$ENCRYPTED_TABLESPACES的功能是查询当前数据库内被加密的表空间,具体用法如下:
1.查看加密的表空间:
“`
SELECT * FROM V$ENCRYPTED_TABLESPACES;
“`
2.查看某个表空间是否被加密:
“`
SELECT * FROM V$ENCRYPTED_TABLESPACES WHERE tablespace_name=’XXX’;
“`
官方英文解释
V$ENCRYPTED_TABLESPACES
displays information about tablespaces that are encrypted.
The information displayed by this view is meaningful only for tablespaces in open containers. This is because the information is derived after the file headers making up a tablespace have been examined during the open operation.
Column | Datatype | Description |
---|---|---|
|
|
Tablespace number |
|
|
Encryption algorithm:
|
|
|
Indicates whether the tablespace is encrypted ( |
|
|
Encrypted version of the tablespace key for the encrypted tablespace |
|
|
ID of the master key that was used to encrypt the tablespace key |
|
|
Number of tablespace blocks that have been encrypted during the lifetime of this instance |
|
|
Number of tablespace blocks that have been decrypted during the lifetime of this instance |
|
|
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 |
|
|
Shows the status of a tablespace. Possible values:
Note: The |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$DATABASE_KEY_INFO”