[Home] [Help] [Dependency Information]
Object Name: | GV_$ENCRYPTION_KEYS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, 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.GV_$ENCRYPTION_KEYS;
|
|
|