Oracle 视图 PDB_PLUG_IN_VIOLATIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图PDB_PLUG_IN_VIOLATIONS是一个只读视图，用于报告某个特定的安装过程及相关的局部数据库（PDB）插入索引的违规情况。当通过Oracle旧金山（Oracle Database 12c）从二进制文件系统（BFS）加载局部数据库（PDB）到容器数据库（CDB）时，进行插件校验（plug-in）检查，如果存在不正确的插件版本、受限制的特性或产品，则会自动报告。PDB_PLUG_IN_VIOLATIONS也可以用于报告PDB被加载到CDB的违规情况。 使用Oracle视图PDB_PLUG_IN_VIOLATIONS的方法取决于要处理的信息类型。要查看PDB被插入时出现的违规情况，可以使用以下查询语句：SELECT * FROM PDB$PLUG_IN_VIOLATIONS;
为了获取更详细的插入违规情况，可以使用以下查询语句：
SELECT * FROM PDB$PLUG_IN_VIOLATIONS WHERE name = ”;
这可以报告某个具体的PDB被插入是报告违规情况，并显示出特定的违规信息，包括违规的特性或产品名称、受影响的PDB、不遵守Oracle安装指南的索引标准和解决方案移行的步骤。
官方英文解释
PDB_PLUG_IN_VIOLATIONS displays information about incompatibilities between a PDB and the CDB to which it belongs.
This view is also used to display information generated by executing DBMS_PDB.CHECK_PLUG_COMPATIBILITY.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Time when a violation described by this row was discovered |
|
|
|
|
The name of an existing PDB or a PDB intended to be created (if a row was entered as a result of running |
|
|
|
|
Attribute which was being checked |
|
|
|
|
|
|
|
|
Oracle error number, if any, encountered during a check |
|
|
|
|
|
Used to differentiate between violations which share a cause |
|
|
|
|
Description of a violation |
|
|
|
|
|
|
|
|
Description of an action to take to correct the violation |
|
|
|
|
The ID of the container to which the data pertains. Possible values:
|
See Also:
Oracle Database PL/SQL
Packages and Types Reference for more information about the DBMS_PDB package, which provides an interface for examining and manipulating data about PDBs
