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.DBA_PDB_SAVED_STATES

Object Details

Object Name:	DBA_PDB_SAVED_STATES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Shows all saved pluggable database states in the consolidated database

[View Source]

Columns

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

Query Text

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.DBA_PDB_SAVED_STATES;

Dependencies

[top of page]

SYS.DBA_PDB_SAVED_STATES references the following:

SYS: INT$DBA_PDB_SAVED_STATES

SYS.DBA_PDB_SAVED_STATES is referenced by following:

PUBLIC: DBA_PDB_SAVED_STATES