Find and compile invalid Maximo objects

Got too many invalid objects in Maximo database. Recompile and make them valid quickly.

 

SELECT 
       'alter '|| object_type || ' "MAXIMO"."'|| object_name || '"  compile;'
FROM   sys.dba_objects
WHERE  status = 'INVALID' AND OWNER = 'MAXIMO'
ORDER BY owner, object_type, object_name;

Share this post

---

Popular posts