UTL_RECOMP invalid

[smacattack]

package UTL_RECOMP is in a invalid state and will not recompile.
How can i get this back to a valid state.
Where can i get the package recreated from ?

thanks

 

[Dagon]

Do:

select * from sys.dba_errors where name = 'UTL_RECOMP'

This will give you some idea what is causing it to fail. Scripts for these sort of packages are part of the standard Oracle installation. I think they're in something like $ORACLE_HOME/rdbms/admin (or windows equivalent).