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

PDB_NAME

VARCHAR2(128)

NOT NULL

Name of this PDB in one of its incarnations

PDB_ID

NUMBER

NOT NULL

Container ID of this PDB in one of its incarnations.

PDB_DBID

NUMBER

NOT NULL

Database ID of this PDB in one of its incarnations

PDB_GUID

RAW(16)

NOT NULL

Globally unique ID of this PDB in one of its incarnations

OP_SCNBAS

NUMBER

NOT NULL

SCN base when an operation was performed on one of the incarnations of this PDB

OP_SCNWRP

NUMBER

NOT NULL

SCN wrap when an operation was performed on one of incarnations of this PDB

OP_TIMESTAMP

DATE

NOT NULL

Timestamp of an operation performed on one of the incarnations of this PDB

OPERATION

VARCHAR2(16)

NOT NULL

Operation that was performed on one of the incarnations of this PDB

DB_VERSION

NUMBER

NOT NULL

Database version

CLONED_FROM_PDB_NAME

VARCHAR2(128)

Name of a PDB from which one of the incarnations of this PDB was cloned

CLONED_FROM_PDB_DBID

NUMBER

Database ID of a PDB from which one of the incarnations of this PDB was cloned

CLONED_FROM_PDB_GUID

RAW(16)

Globally unique ID of a PDB from which one of the incarnations of this PDB was cloned

DB_NAME

VARCHAR2(128)

Name of a CDB in which one of the incarnations of this PDB was created

DB_UNIQUE_NAME

VARCHAR2(128)

Unique name of a CDB in which one of the incarnations of this PDB was created

DB_DBID

NUMBER

Database ID of a CDB in which one of the incarnations of this PDB was created

CLONETAG

VARCHAR2(128)

Clone tag name for the PDB if the PDB was cloned using the snapshot copy mechanism

DB_VERSION_STRING

VARCHAR2(204)

Database version string


数据运维技术 » Oracle 视图 DBA_PDB_HISTORY 官方解释,作用,如何使用详细说明