SQL> col OWNER format a10 SQL> col OBJECT_TYPE format a30 SQL> col STATUS format a20 SQL> / OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMAPPPREP INDEX VALID 21 RODMU BPMAPPPREP LOB VALID 21 RODMU BPMAPPPREP PACKAGE VALID 3 RODMU BPMAPPPREP PACKAGE BODY INVALID 1 RODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMAPPPREP PACKAGE BODY VALID 2 RODMU BPMAPPPREP SEQUENCE VALID 30 RODMU BPMAPPPREP SYNONYM VALID 1 RODMU BPMAPPPREP TABLE VALID 29 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- RODMU BPMAPPUATM INDEX VALID 21 U BPMAPPUATM LOB VALID 21 U BPMAPPUATM PACKAGE VALID 4 U OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMAPPUATM PACKAGE BODY INVALID 1 U BPMAPPUATM PACKAGE BODY VALID 3 U BPMAPPUATM SEQUENCE VALID 31 U BPMAPPUATM SYNONYM VALID 2 U OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMAPPUATM TABLE VALID 29 U BPMDATAPRE FUNCTION VALID 2 PRODMU BPMDATAPRE INDEX VALID 78 PRODMU BPMDATAPRE LOB VALID 78 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- PRODMU BPMDATAPRE PACKAGE VALID 4 PRODMU BPMDATAPRE PACKAGE BODY INVALID 1 PRODMU BPMDATAPRE PACKAGE BODY VALID 3 PRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMDATAPRE PROCEDURE VALID 1 PRODMU BPMDATAPRE SEQUENCE VALID 45 PRODMU BPMDATAPRE SYNONYM VALID 2 PRODMU BPMDATAPRE TABLE VALID 38 PRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMDATAUAT FUNCTION VALID 2 MU BPMDATAUAT INDEX VALID 80 MU BPMDATAUAT LOB VALID 80 MU BPMDATAUAT PACKAGE VALID 4 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- MU BPMDATAUAT PACKAGE BODY VALID 4 MU BPMDATAUAT PROCEDURE VALID 1 MU BPMDATAUAT SEQUENCE VALID 47 MU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMDATAUAT SYNONYM VALID 2 MU BPMDATAUAT TABLE VALID 40 MU BPMENGPREP INDEX VALID 6 RODMU BPMENGPREP LOB VALID 6 RODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMENGPREP SEQUENCE VALID 1 RODMU BPMENGPREP TABLE VALID 49 RODMU BPMENGUATM INDEX VALID 6 U BPMENGUATM LOB VALID 6 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- U BPMENGUATM PACKAGE VALID 2 U BPMENGUATM PACKAGE BODY INVALID 2 U BPMENGUATM SEQUENCE VALID 2 U OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMENGUATM TABLE VALID 50 U BPMINS_APP SYNONYM VALID 20 UATMU BPMINS_ENG INDEX VALID 5 PREPRODMU BPMINS_ENG LOB VALID 5 PREPRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMINS_ENG TABLE VALID 48 PREPRODMU BPMINS_ENG INDEX VALID 5 UATMU BPMINS_ENG LOB VALID 5 UATMU BPMINS_ENG TABLE VALID 48 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- UATMU BPMPAY_APP INDEX VALID 7 UATMU BPMPAY_APP LOB VALID 7 UATMU BPMPAY_APP SEQUENCE VALID 9 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMPAY_APP SYNONYM VALID 19 UATMU BPMPAY_APP TABLE VALID 9 UATMU BPMPAY_ENG INDEX VALID 5 PREPRODMU BPMPAY_ENG LOB VALID 5 PREPRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMPAY_ENG TABLE VALID 48 PREPRODMU BPMPAY_ENG INDEX VALID 5 UATMU BPMPAY_ENG LOB VALID 5 UATMU BPMPAY_ENG TABLE VALID 48 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- UATMU BPMQWO_APP INDEX VALID 7 PREPRODMU BPMQWO_APP LOB VALID 7 PREPRODMU BPMQWO_APP SEQUENCE VALID 10 PREPRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMQWO_APP SYNONYM VALID 22 PREPRODMU BPMQWO_APP TABLE VALID 10 PREPRODMU BPMQWO_APP INDEX VALID 7 UATMU BPMQWO_APP LOB VALID 7 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMQWO_APP SEQUENCE VALID 10 UATMU BPMQWO_APP SYNONYM VALID 22 UATMU BPMQWO_APP TABLE VALID 10 UATMU BPMQWO_ENG INDEX VALID 5 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- PREPRODMU BPMQWO_ENG LOB VALID 5 PREPRODMU BPMQWO_ENG SYNONYM VALID 1 PREPRODMU BPMQWO_ENG TABLE VALID 48 PREPRODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMQWO_ENG INDEX VALID 5 UATMU BPMQWO_ENG LOB VALID 5 UATMU BPMQWO_ENG SYNONYM VALID 1 UATMU BPMQWO_ENG TABLE VALID 49 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMTRS_APP INDEX VALID 8 PREPRODMU BPMTRS_APP LOB VALID 8 PREPRODMU BPMTRS_APP SEQUENCE VALID 8 PREPRODMU BPMTRS_APP SYNONYM VALID 21 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- PREPRODMU BPMTRS_APP TABLE VALID 9 PREPRODMU BPMTRS_APP INDEX VALID 8 UATMU BPMTRS_APP LOB VALID 8 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMTRS_APP PACKAGE VALID 1 UATMU BPMTRS_APP PACKAGE BODY INVALID 1 UATMU BPMTRS_APP SEQUENCE VALID 9 UATMU BPMTRS_APP SYNONYM VALID 24 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMTRS_APP TABLE VALID 10 UATMU BPMTRS_ENG INDEX VALID 5 PREPRODMU BPMTRS_ENG LOB VALID 5 PREPRODMU BPMTRS_ENG SYNONYM VALID 1 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- PREPRODMU BPMTRS_ENG TABLE VALID 48 PREPRODMU BPMTRS_ENG INDEX VALID 5 UATMU BPMTRS_ENG LOB VALID 5 UATMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- BPMTRS_ENG SYNONYM VALID 1 UATMU BPMTRS_ENG TABLE VALID 48 UATMU CAMUNDAPRE INDEX VALID 6 PRODMUWFT CAMUNDAPRE LOB VALID 6 PRODMUWFT OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- CAMUNDAPRE SEQUENCE VALID 1 PRODMUWFT CAMUNDAPRE TABLE VALID 50 PRODMUWFT CAMUNDAPRO INDEX VALID 5 DMUWFT CAMUNDAPRO LOB VALID 5 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- DMUWFT CAMUNDAPRO PACKAGE VALID 1 DMUWFT CAMUNDAPRO PACKAGE BODY VALID 1 DMUWFT CAMUNDAPRO SEQUENCE VALID 3 DMUWFT OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- CAMUNDAPRO TABLE VALID 50 DMUWFT CAMUNDAQAM INDEX VALID 5 UWFT CAMUNDAQAM LOB VALID 5 UWFT CAMUNDAQAM PACKAGE VALID 1 UWFT OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- CAMUNDAQAM PACKAGE BODY VALID 1 UWFT CAMUNDAQAM SEQUENCE VALID 3 UWFT CAMUNDAQAM TABLE VALID 50 UWFT CAMUNDAUAT INDEX VALID 8 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- MUWFT CAMUNDAUAT LOB VALID 8 MUWFT CAMUNDAUAT PACKAGE VALID 2 MUWFT CAMUNDAUAT PACKAGE BODY VALID 2 MUWFT OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- CAMUNDAUAT SEQUENCE VALID 11 MUWFT CAMUNDAUAT TABLE VALID 60 MUWFT DOLLARU FUNCTION VALID 2 DOLLARU PROCEDURE INVALID 1 MWBPMDEVMU SEQUENCE VALID 1 MWBPMDEVMU TABLE VALID 4 MWBPMPREPR INDEX VALID 8 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- ODMU MWBPMPREPR LOB VALID 8 ODMU MWBPMPREPR SEQUENCE VALID 52 ODMU MWBPMPREPR TABLE VALID 99 ODMU OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- MWBPMUATMU INDEX VALID 8 MWBPMUATMU LOB VALID 8 MWBPMUATMU SEQUENCE VALID 54 MWBPMUATMU TABLE VALID 101 PUBLIC DATABASE LINK VALID 1 PUBLIC SYNONYM VALID 7939 ZABBIX JOB VALID 1 ZABBIX PROCEDURE INVALID 1 ZABBIX SYNONYM VALID 6 ZABBIX TABLE VALID 3 ZABBIX VIEW INVALID 1 OWNER OBJECT_TYPE STATUS COUNT(*) ---------- ------------------------------ -------------------- ---------- ZABBIX VIEW VALID 3 143 rows selected. SQL>