Oracle 视图 DBA_PDB_HISTORY 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_PDB_HISTORY提供了Oracle的PDB的历史信息。该视图是生成的,不可以写入数据或修改数据,只能用来查看数据。该视图可以用来查看PBD操作的历史记录,包括PBD的创建,关闭、拷贝,迁移等信息。
可使用的SQL语句来查询DBA_PDB_HISTORY视图中的数据,其语法结构如下:
SELECT * FROM DBA_PDB_HISTORY;
该语句可以获得DBA_PDB_HISTORY视图中的所有列的数据。
官方英文解释
DBA_PDB_HISTORY
describes the lineage of the PDB to which it belongs.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of this PDB in one of its incarnations |
|
|
|
Container ID of this PDB in one of its incarnations. |
|
|
|
Database ID of this PDB in one of its incarnations |
|
|
|
Globally unique ID of this PDB in one of its incarnations |
|
|
|
SCN base when an operation was performed on one of the incarnations of this PDB |
|
|
|
SCN wrap when an operation was performed on one of incarnations of this PDB |
|
|
|
Timestamp of an operation performed on one of the incarnations of this PDB |
|
|
|
Operation that was performed on one of the incarnations of this PDB |
|
|
|
Database version |
|
|
Name of a PDB from which one of the incarnations of this PDB was cloned |
|
|
|
Database ID of a PDB from which one of the incarnations of this PDB was cloned |
|
|
|
Globally unique ID of a PDB from which one of the incarnations of this PDB was cloned |
|
|
|
Name of a CDB in which one of the incarnations of this PDB was created |
|
|
|
Unique name of a CDB in which one of the incarnations of this PDB was created |
|
|
|
Database ID of a CDB in which one of the incarnations of this PDB was created |
|
|
|
Clone tag name for the PDB if the PDB was cloned using the snapshot copy mechanism |
|
|
|
Database version string |