Tuesday, December 22, 2009

V$ENCRYPTION_WALLET

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


V$ENCRYPTION_WALLET displays information on the status of the wallet and the wallet location for transparent data encryption.
Column
Datatype
Description
WRL_TYPE
VARCHAR2(20)
Type of the wallet resource locator (for example, FILE)
WRL_PARAMETER
VARCHAR2(4000)
Parameter of the wallet resource locator (for example, absolute filename if WRL_TYPE = FILE)
STATUS
VARCHAR2(9)
Status of the wallet:
  • OPEN
  • CLOSED
  • UNDEFINED

Note:
1.       Is there any view to tell if wallet is opened or not? Use V$ENCRYPTION_WALLET, which is a feature available in 10.2.0.4 and 11g database versions.

Oracle data dictionary views

Last updated: 2009-12-22 Tuesday