User Tools

Site Tools


tech:rdbms:ora_invalid_objects

Oracle Invalid Objects

Note: Run SQL below as SYS (connect as sysdba)
Are there any invalid objects?

select owner,object_type,object_name from dba_objects where status != 'VALID' order by owner, object_type;

Rebuild all invalid PACKAGE/PACKAGE BODY etc.

exec UTL_RECOMP.RECOMP_SERIAL ();

Are there any bad indices?

select owner, index_name from dba_indexes where status like 'UN%';
tech/rdbms/ora_invalid_objects.txt · Last modified: 2024/06/21 12:04 by 127.0.0.1