Re: utlrp and show errors

IIRC show errors shows errors from the last compiled object by default, show errors <object type> <object name> is needed for the details though then you'd need to know the name and mght as well select from da_errors

On Tue, Jun 3, 2008 at 8:47 PM, Newman, Christopher <cjnewman_at_uillinois.edu> wrote:

> Hello,
>
> When running utlrp to recompile invalid objects on 10.2.0.3, Solaris 64bit
> 8, it gives something similar to the below:
>
> …
>
> OBJECTS WITH ERRORS
>
> -------------------
>
> 25
>
> However… then typing 'show errors' returns nothing. These errors can
> still be found in dba_errors, but I am wondering why 'show errors' always
> returns null when the recompile encountered errors.
>
> Thanks- Chris
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l