Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$ENCRYPTION_KEYS

V$ENCRYPTION_KEYS displays master key description attributes.

Column Datatype Description
KEY_ID VARCHAR2(78) Master key identifier
TAG VARCHAR2(4000) Associated user-defined Information with the master key
CREATION_TIME TIMESTAMP(6) WITH TIME ZONE Time that the master key was created
ACTIVATION_TIME TIMESTAMP(6) WITH TIME ZONE Time that the master key was put into use
CREATOR VARCHAR2(30) User that created the master key
CREATOR_ID NUMBER User ID that created the master key
USER VARCHAR2(30) User that activated the master key
USER_ID NUMBER User ID that activated the master key
KEY_USE VARCHAR2(10) Indicates whether the master key is used for TDE operations in a PDB or not
KEYSTORE_TYPE VARCHAR2(17) Master key is in:
  • HSM - Hardware Security Module

  • SOFTWARE KEYSTORE

  • UNDEFINED - This value is shown if the keystore has no information about the type of keystore where the master key resides

ORIGIN VARCHAR2(41) Provides information about the origin of the master key:
  • 1 - Was created locally in this database

  • 2 - Was imported from another database

  • 3 - Was imported but the key metadata was created locally due to activation

  • 4 - Unknown if the key was imported or created locally but the key metadata was created locally due to activation

  • 5 - Status of the master key is unknown.

BACKED_UP VARCHAR2(9) Indicates whether the key has been backed up or not
CREATOR_DBNAME VARCHAR2(30) Database that created the key
CREATOR_DBID NUMBER Database ID where the key was created
CREATOR_INSTANCE_NAME VARCHAR2(30) Instance name of the instance where the key was created
CREATOR_INSTANCE_NUMBER NUMBER Instance number of the instance where the key was created
CREATOR_INSTANCE_SERIAL NUMBER Serial number of the instance where the key was created
CREATOR_PDBNAME VARCHAR2(30) PDB where the key was created
CREATOR_PDBID NUMBER PDB ID where the key was created
CREATOR_PDBUID NUMBER PDB UID where the key was created
CREATOR_PDBGUID RAW(16) PDB GUID where the key was created
ACTIVATING_DBNAME VARCHAR2(30) Database that activated the key
ACTIVATING_DBID NUMBER Database ID where the key was activated
ACTIVATING_INSTANCE_NAME VARCHAR2(30) Instance name of the instance where the key was activated
ACTIVATING_INSTANCE_NUMBER NUMBER Instance number of the instance where the key was activated
ACTIVATING_INSTANCE_SERIAL NUMBER Serial number of the instance where the key was activated
ACTIVATING_PDBNAME VARCHAR2(30) PDB where the key was activated
ACTIVATING_PDBID NUMBER PDB ID where the key was activated
ACTIVATING_PDBUID NUMBER PDB UID where the key was activated
ACTIVATING_PDBGUID RAW(16) PDB GUID where the key was activated
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


See Also:

Oracle Database Advanced Security Guide for information about keystore management