Oracle 视图 DBA_LOGMNR_DICTIONARY_BUILDLOG 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 DBA_LOGMNR_DICTIONARY_BUILDLOG 视图是全局视图，显示在LogMiner字典中定义的列和数据类型信息。DBA_LOGMNR_DICTIONARY_BUILDLOG 视图用于查看在LogMiner字典中定义的列和数据类型信息，支持的数据字典来源包括Internet Directory、Sybase、Oracle、MS SQL Server、DB2 方案。
使用 Oracle 视图 DBA_LOGMNR_DICTIONARY_BUILDLOG 需要在SQL *Plus中运行并绑定其输出列：
SELECT dictionary_name, dictionary_description, dictionary_build_time, dictionary_version FROM dba_logmnr_dictionary_buildlog;
官方英文解释
DBA_LOGMNR_DICTIONARY_BUILDLOG describes all successful LogMiner dictionary builds available for GoldenGate REGISTER EXTRACT.
When this view is queried from a PDB, it returns only LogMiner dictionary builds performed in that PDB.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
User-supplied name of the LogMiner dictionary build |
|
|
|
|
Date and time at which the LogMiner dictionary build was performed |
|
|
|
|
Begin SCN of the LogMiner dictionary build operation |
|
|
|
|
End SCN of the LogMiner dictionary build operation |
|
|
|
|
Internal string that identifies how the LogMiner dictionary build was initiated |
|
|
|
|
Internal number that identifies how the LogMiner dictionary build was initiated |
|
|
|
|
ID of the container in which the LogMiner dictionary build was performed (the CDB root or a PDB) |
|
|
|
|
Unique number that identifies the container in which the LogMiner dictionary build was performed (the CDB root or a PDB) |
|
|
|
|
Name of the container in which the LogMiner dictionary build was performed (the CDB root or a PDB) |
|
|
|
|
SCN that identifies the redo branch of the LogMiner dictionary build |
Note:
This view is available starting with Oracle Database 21c.
