Invalid Objects

Q: How can invalid PDB objects be compiled?

A: Each schema user is able to compile his objects himself. The Pluggable Database user PDBADMIN is able to compile invalid object in other PDB schemas. Example:

List invalid objects:

SELECT owner,
       object_type,
       object_name,
       status
FROM   dba_objects
WHERE  status = 'INVALID'
ORDER BY owner, object_type, object_name;

Compile invalid objects in schema:

BEGIN
  DBMS_UTILITY.COMPILE_SCHEMA(schema => 'CRM01', compile_all => FALSE);
END;

Q: Where do I get more Information about compiling invalid database objects?

A: Read this PL/SQL Packages and Types Reference - DBMS_UTILITY.