Tag Archives: invalid object

Check the invalid objects in CDB & PDB Oracle

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

Advertisements