7.217 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 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