Recompile Invalid objects in PDB database (Multitenant)

 RECOMPILE INVALID OBJECTS IN PDB (PLUGGABLE DATABASE)

conn / as sysdba alter session set container=PDB$SEED; show con_name select open_mode from v$database; alter session set "_oracle_script"=TRUE; alter pluggable database pdb$seed close immediate instances=all; select open_mode from v$database; alter pluggable database pdb$seed OPEN READ WRITE; show con_name; select open_mode from v$database; @?/rdbms/admin/utlrp.sql col COMP_NAME for a35; col COMP_ID for a10; set linesize 120; select comp_id, comp_name, version, status from dba_registry; select count(*) from dba_objects where status='INVALID'; col OBJECT_NAME for a30; select object_name, object_type, owner from dba_objects where status='INVALID' order by owner; select owner, object_type, count(*) from dba_objects where status = 'INVALID' group by owner, object_type; alter pluggable database pdb$seed close immediate instances=all; alter pluggable database pdb$seed OPEN READ ONLY; show con_name; select open_mode from v$database; alter session set "_oracle_script"=FALSE;