Skip to content
Home » Oracle » PDB_PLUG_IN_VIOLATIONS, How and Why



PDB_PLUG_IN_VIOLATIONS is a dictionary view for displaying incompatible information or violations about the PDB to the CDB which it plugs in.

Usually, we use it to look up errors whenever we have some difficulties to open the newly cloned PDB from another CDB, according to the hints from the alert log.

In fact, before you look up PDB_PLUG_IN_VIOLATIONS, the very first error message you saw could be at opening the PDB:

SQL> alter pluggable database ORCLPDB open;

Warning: PDB altered with errors.

To solve "Warning: PDB altered with errors.", we have 2 cases for you.

  1. SQL patch level mismatch
  2. Common user's default tablespace

You may have a look.

Leave a Reply

Your email address will not be published. Required fields are marked *