Recompiling All Invalid Objects in Oracle
Check the invalid objects and generate script for compiling
SELECT owner,
'alter ' || REPLACE( object_type, ' BODY',
'') || ' ' || owner || '.' || object_name || ' compile ' || DECODE
(object_type, 'PACKAGE BODY', 'BODY', '' ) || ';' "Compile-Syntax"
FROM all_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type, object_name
ORDER BY owner, object_type, object_name;
OR
The utlrp.sql script recompiles all invalid objects.
1. Change directory to Oracle_home/rdbms/admin.
$ cd $ORACLE_HOME/rdbms/admin
2. Connect as sysdba and run the script
$sqlplus "/as sysdba"
SQL>@utlrp.sql
Tags:
Oracle