[Home] [Help] [Dependency Information]
Object Name: | CDB_PDB_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Describes lineage of the pluggable database to which it belongs in all containers
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 | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_PDB_HISTORY;
SYS.CDB_PDB_HISTORY does not reference any database object
SYS.CDB_PDB_HISTORY is referenced by following:
|
|
|