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 |
标签:视图,数据,语句,不可以,信息