Check the invalid objects in CDB & PDB
Check the Name of Invalid Object
SQL> select object_name from cdb_objects where status='INVALID';
OBJECT_NAME
---------------------------
PN
Check the count of Invalid objects
select count(*) from cdb_objects where status='INVALID';
COUNT(*)
----------
1
Check the Invalid object container id
select con_id,count(*) from cdb_objects where status = ‘INVALID’ group by con_id;
CON_ID COUNT(*) ---------- ---------- 1 1
Check the owner, pid name, type of invalid object
col name for a10
col owner for a8
col object_type for a10
select t.con_id,p.name,t.owner,t.object_type,count(*) from cdb_objects t ,v$containers p
where p.con_id = t.con_id and t.status = 'INVALID' group by t.con_id,p.name,t.owner,t.object_type;
CON_ID NAME OWNER OBJECT_TYP COUNT(*) ---------- ---------- -------- ---------- ---------- 1 CDB$ROOT SYS PROCEDURE 1