[Home] [Help] [Dependency Information]
Object Name: | CDB_PDB_SAVED_STATES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Shows all saved pluggable database states in the consolidated database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CON_ID | NUMBER | Yes | Id of the pluggable database | |
CON_NAME | VARCHAR2 | (128) | Yes | Name of the pluggable database |
INSTANCE_NAME | VARCHAR2 | (128) | Yes | name of the instance for which the state is saved |
CON_UID | NUMBER | Yes | Unique ID assigned to the PDB at creation time | |
GUID | RAW | (16) | Globally unique immutable ID assigned to the PDB at creation time | |
STATE | VARCHAR2 | (14) | Open state of the pluggable database | |
RESTRICTED | VARCHAR2 | (3) | Restricted mode of the pluggable database |
Cut, paste (and edit) the following text to query this object:
SELECT CON_ID
, CON_NAME
, INSTANCE_NAME
, CON_UID
, GUID
, STATE
, RESTRICTED
FROM SYS.CDB_PDB_SAVED_STATES;
SYS.CDB_PDB_SAVED_STATES does not reference any database object
SYS.CDB_PDB_SAVED_STATES is referenced by following:
|
|
|