-- invalid components after the upgradeset line 180set pagesize 50
COL COMP_ID for a10
COL COMP_NAME for a40
COL VERSION for a20
COL VERSION_FULL for a20
COL STATUS for a15
COL SCHEMA for a15
SELECT COMP_ID, COMP_NAME,VERSION,STATUS,SCHEMA,VERSION_FULL
FROM SYS.DBA_REGISTRY
WHERE STATUS ='INVALID';
-- invalid objects after the upgradeset line 180set pagesize 50
col OWNER for a11
col OBJECT_NAME for a40
col OBJECT_TYPE for a20
SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
FROM SYS.DBA_OBJECTS
WHERE STATUS ='INVALID'orderby OBJECT_NAME,OWNER;
set line 180set pagesize 50
col OWNER# for999999
col TYPE# for99999
col name for a30
SELECT OWNER#, TYPE#, NAME
FROM SYS.OBJ$ WHERE STATUS !=1;
SELECT NAME, SUBNAME FROM SYS.OBJ$
WHERE STATUS >1AND TYPE# =13;
SELECT OBJ# ||' '|| COMPILE_ERR AS INVALID_COMPILE_OBJS
FROM SYS.UTL_RECOMP_ERRORS;
-- database errorsset line 180set pagesize 50
col OWNER for a11
col name for a30
col error for a100
SELECT OWNER,NAME,SUBSTR(TEXT,1,750) AS ERROR
FROM SYS.DBA_ERRORS;
-- system componentsset line 180set pagesize 50
col OBJECT_NAME for a40
col OBJECT_TYPE for a20
col OWNER for a11
SELECT OBJECT_NAME, OBJECT_TYPE, OWNER
FROM SYS.DBA_INVALID_OBJECTS
WHERE OWNER in ('SYS','SYSTEM')
orderby OWNER, OBJECT_TYPE;
set line 180set pagesize 50
col OBJECT_NAME for a40
col OBJECT_TYPE for a20
col OWNER for a11
SELECT OBJECT_NAME ,OBJECT_TYPE
FROM SYS.DBA_INVALID_OBJECTS
WHERE OWNER NOTIN ('SYS','SYSTEM','SYSMAN');