[Home] [Help] [Dependency Information]
Object Name: | V_$CONTAINERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CON_ID | NUMBER | |||
DBID | NUMBER | |||
CON_UID | NUMBER | |||
GUID | RAW | (16) | ||
NAME | VARCHAR2 | (30) | ||
OPEN_MODE | VARCHAR2 | (10) | ||
RESTRICTED | VARCHAR2 | (3) | ||
OPEN_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
CREATE_SCN | NUMBER | |||
TOTAL_SIZE | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
RECOVERY_STATUS | VARCHAR2 | (8) | ||
SNAPSHOT_PARENT_CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CON_ID
, DBID
, CON_UID
, GUID
, NAME
, OPEN_MODE
, RESTRICTED
, OPEN_TIME
, CREATE_SCN
, TOTAL_SIZE
, BLOCK_SIZE
, RECOVERY_STATUS
, SNAPSHOT_PARENT_CON_ID
FROM SYS.V_$CONTAINERS;
|
|
|