SQL to find invalid object types which are owned by owner

OWNER                     OBJECT_TYPE                    OBJECT_COUNT
------------------------- ------------------------------ ------------
TEST_USER1	              PROCEDURE                                 2
TEST_USER2                    PROCEDURE                                 2
-------------------------------
Trimmed Data
-------------------------------
5 rows selected.

SQL>
$$$$$$$**Welcome to DBsGuru!**Learn Share Grow**$$$$$$$

++++++++++++++++++++++++++++++++
SQL to find all invalid objects in database.

OWNER                     OBJECT_NAME                              OBJECT_TYPE
------------------------- ---------------------------------------- ------------------------------
TEST_USER1                PRC_TEST1                   		   PROCEDURE
TEST_USER1                PRC_TEST2                   		   PROCEDURE
-------------------------------
Trimmed Data
-------------------------------

13 rows selected.

SQL>
$$$$$$$**Welcome to DBsGuru!**Learn Share Grow**$$$$$$$