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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.