Recompila os objetos inválidos

 

EXEC DBMS_UTILITY.compile_schema(schema => 'NOME_DO_SCHEMA');

COLUMN object_name FORMAT A30
SELECT owner,
       object_type,
       object_name,
       status
FROM   dba_objects
WHERE  status = 'INVALID' AND owner = 'SENIOR'
ORDER BY owner, object_type, object_name;