eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$ENCRYPTION_KEYS

Object Details

Object Name:	V_$ENCRYPTION_KEYS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
KEY_ID	VARCHAR2	(78)
TAG	VARCHAR2	(4000)
CREATION_TIME	TIMESTAMP(6) WITH TIME ZONE	(20)
ACTIVATION_TIME	TIMESTAMP(6) WITH TIME ZONE	(20)
CREATOR	VARCHAR2	(30)
CREATOR_ID	NUMBER
USER	VARCHAR2	(30)
USER_ID	NUMBER
KEY_USE	VARCHAR2	(10)
KEYSTORE_TYPE	VARCHAR2	(17)
ORIGIN	VARCHAR2	(41)
BACKED_UP	VARCHAR2	(9)
CREATOR_DBNAME	VARCHAR2	(30)
CREATOR_DBID	NUMBER
CREATOR_INSTANCE_NAME	VARCHAR2	(30)
CREATOR_INSTANCE_NUMBER	NUMBER
CREATOR_INSTANCE_SERIAL	NUMBER
CREATOR_PDBNAME	VARCHAR2	(30)
CREATOR_PDBID	NUMBER
CREATOR_PDBUID	NUMBER
CREATOR_PDBGUID	RAW	(16)
ACTIVATING_DBNAME	VARCHAR2	(30)
ACTIVATING_DBID	NUMBER
ACTIVATING_INSTANCE_NAME	VARCHAR2	(30)
ACTIVATING_INSTANCE_NUMBER	NUMBER
ACTIVATING_INSTANCE_SERIAL	NUMBER
ACTIVATING_PDBNAME	VARCHAR2	(30)
ACTIVATING_PDBID	NUMBER
ACTIVATING_PDBUID	NUMBER
ACTIVATING_PDBGUID	RAW	(16)
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT KEY_ID
,      TAG
,      CREATION_TIME
,      ACTIVATION_TIME
,      CREATOR
,      CREATOR_ID
,      USER
,      USER_ID
,      KEY_USE
,      KEYSTORE_TYPE
,      ORIGIN
,      BACKED_UP
,      CREATOR_DBNAME
,      CREATOR_DBID
,      CREATOR_INSTANCE_NAME
,      CREATOR_INSTANCE_NUMBER
,      CREATOR_INSTANCE_SERIAL
,      CREATOR_PDBNAME
,      CREATOR_PDBID
,      CREATOR_PDBUID
,      CREATOR_PDBGUID
,      ACTIVATING_DBNAME
,      ACTIVATING_DBID
,      ACTIVATING_INSTANCE_NAME
,      ACTIVATING_INSTANCE_NUMBER
,      ACTIVATING_INSTANCE_SERIAL
,      ACTIVATING_PDBNAME
,      ACTIVATING_PDBID
,      ACTIVATING_PDBUID
,      ACTIVATING_PDBGUID
,      CON_ID
FROM SYS.V_$ENCRYPTION_KEYS;

Dependencies

[top of page]

SYS.V_$ENCRYPTION_KEYS references the following:

SYS.V_$ENCRYPTION_KEYS is referenced by following:

PUBLIC: V$ENCRYPTION_KEYS