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_PDBS

Object Details

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

Describes all pluggable databases in the consolidated database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PDB_ID	NUMBER		Yes	Id of the pluggable database
PDB_NAME	VARCHAR2	(128)	Yes	Name of the pluggable database
DBID	NUMBER		Yes	Database id of the pluggable database
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
STATUS	VARCHAR2	(9)		Status of the pluggable database
CREATION_SCN	NUMBER			SCN for when the pluggable database was created/plugged
VSN	NUMBER
LOGGING	VARCHAR2	(9)
FORCE_LOGGING	VARCHAR2	(3)
FORCE_NOLOGGING	VARCHAR2	(3)
CON_ID	NUMBER		Yes	Id of the pluggable database

Query Text

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


SELECT PDB_ID
,      PDB_NAME
,      DBID
,      CON_UID
,      GUID
,      STATUS
,      CREATION_SCN
,      VSN
,      LOGGING
,      FORCE_LOGGING
,      FORCE_NOLOGGING
,      CON_ID
FROM SYS.DBA_PDBS;

Dependencies

[top of page]

SYS.DBA_PDBS references the following:

SYS: INT$DBA_PDBS

SYS.DBA_PDBS is referenced by following:

PUBLIC: DBA_PDBS
SYS: DBMS_LOGMNR_INTERNAL - show dependent code