PDB_PLUG_IN_VIOLATIONS

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 TIMESTAMP(6) NOT NULL Time when a violation described by this row was discovered
NAME VARCHAR2(128) NOT NULL The name of an existing PDB or a PDB intended to be created (if a row was entered as a result of running DBMS_PDB.CHECK_PLUG_COMPATIBILITY)
CAUSE VARCHAR2(64) NOT NULL Attribute which was being checked
TYPE VARCHAR2(9) NOT NULL ERROR or WARNING
ERROR_NUMBER NUMBER   Oracle error number, if any, encountered during a check
LINE NUMBER NOT NULL Used to differentiate between violations which share a cause
MESSAGE VARCHAR2(4000) NOT NULL Description of a violation
STATUS VARCHAR2(9)   PENDING, RESOLVED, or IGNORE
ACTION VARCHAR2(4000)   Description of an action to take to correct the violation
CON_ID NUMBER  

The ID of the container to which the data pertains. Possible values:

  • 0: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also: Oracle AI 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