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_HISTORY

Object Details

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

Describes lineage of the pluggable database to which it belongs

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PDB_NAME	VARCHAR2	(128)	Yes	Name of this pluggable database in one of its incarnations
PDB_ID	NUMBER		Yes	Id of this pluggable database in one of its incarnations
PDB_DBID	NUMBER		Yes	Database id of this pluggable database in one of its incarnations
PDB_GUID	RAW	(16)	Yes	Globally unique id of this pluggable database in one of its incarnations
OP_SCNBAS	NUMBER		Yes	SCN base when an operation was performed on one of incarnations of this pluggable database
OP_SCNWRP	NUMBER		Yes	SCN wrap when an operation was performed on one of incarnations of this pluggable database
OP_TIMESTAMP	DATE		Yes	Timestamp of an operation performed on one of incarnations of this pluggable database
OPERATION	VARCHAR2	(16)	Yes	Operation that was performed on one of incarnations of this pluggable database
DB_VERSION	NUMBER		Yes	Database version
CLONED_FROM_PDB_NAME	VARCHAR2	(128)		Name of a pluggable database from which one of incarnations of this pluggable database was cloned
CLONED_FROM_PDB_DBID	NUMBER			Database id of a pluggable database from which one of incarnations of this pluggable database was cloned
CLONED_FROM_PDB_GUID	RAW	(16)		Globally unique id of a pluggable database from which one of incarnations of this pluggable database was cloned
DB_NAME	VARCHAR2	(128)		Name of a consolidation database in which one of incarnations of this pluggable database was created
DB_UNIQUE_NAME	VARCHAR2	(128)		Unique name of a consolidation database in which one of incarnations of this pluggable database was created
DB_DBID	NUMBER			Database id of a consolidation database in which one of incarnations of this pluggable database was created
CLONETAG	VARCHAR2	(128)		clone tag name for the pdb if the pdb was cloned using snapshot copy mechanism

Query Text

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


SELECT PDB_NAME
,      PDB_ID
,      PDB_DBID
,      PDB_GUID
,      OP_SCNBAS
,      OP_SCNWRP
,      OP_TIMESTAMP
,      OPERATION
,      DB_VERSION
,      CLONED_FROM_PDB_NAME
,      CLONED_FROM_PDB_DBID
,      CLONED_FROM_PDB_GUID
,      DB_NAME
,      DB_UNIQUE_NAME
,      DB_DBID
,      CLONETAG
FROM SYS.DBA_PDB_HISTORY;

Dependencies

[top of page]

SYS.DBA_PDB_HISTORY references the following:

SYS: PDB_HISTORY$

SYS.DBA_PDB_HISTORY is referenced by following:

PUBLIC: DBA_PDB_HISTORY