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/02/21 19:09 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki