Oracle 视图 V$WALLET 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 V$WALLET 提供信息，显示 Oracle 钱包 (Oracle Wallet) 的内容。Oracle 钱包是存有认证信息的物理文件，关联存储在客户端或服务器上的私钥和证书。
使用该视图，您可以查看有关 Oracle 钱包实例、位置和类型的信息。它还提供有关私钥条目的信息，例如关联的 CNAM、UUID 和私钥等。
使用此视图的步骤：
1.使用SQL *Plus或者使用PL / SQL Developer客户端等工具连接到Oracle服务器
2.执行以下查询：
select * from v$wallet;
3.查看视图中的内容
官方英文解释
V$WALLET displays metadata of certificates that may be used as a master key for Transparent Data Encryption.
Note:
The use of PKI encryption with Transparent Data Encryption is deprecated. To configure Transparent Data Encryption, use the ADMINISTER KEY MANAGEMENT SQL statement. See Oracle Database Advanced
Security Guide for more information.
| Column | Datatype | Description |
|---|---|---|
|
|
|
A unique certificate identifier value used to specify a particular PKI certificate for use as the master key |
|
|
|
Distinguished name of a particular PKI certificate |
|
|
|
Unique serial number assigned to a certificate by the issuer or signer |
|
|
|
Distinguished name of the Certificate Authority or issuer that issued and signed the certificate |
|
|
|
Size of the PKI key associated with the certificate |
|
|
|
Current status of the certificate:
This column allows the user to identify whether a certificate is currently in use or has already been used for Transparent Data Encryption. |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
