Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

Re: utlrp and show errors

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: cjnewman@xxxxxxxxxxxxx
  • Date: Tue, 3 Jun 2008 22:06:41 +0100
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@xxxxxxxxxxxxx>
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

Other related posts:

  • utlrp and show errors
  • Re: utlrp and show errors
  • RE: utlrp and show errors




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.