RE: utlrp and show errors

From: M Rafiq <>
Date: Wed, 4 Jun 2008 09:41:35 -0400
Message-ID: <BAY107-W46951A5331642FC359964DA1B50@phx.gbl>


Run the following script to identify objects with errors.  

set linesize 120set echo offcol Owner format a20 justify c heading 'Owner'col Object_Name format a30 justify c heading 'Object_Name'col Object_type format a15 justify c heading 'Object_type'col Created format a9 justify c heading 'Created'col timestamp format a20 justify c heading 'Timestamp'col Status format a7 justify c heading 'Status' select substr(owner,1,15)OWNER,substr(object_name,1,70)OBJECT_NAME,substr(object_type,1,18)OBJECT_TYPE,created CREATED,substr(timestamp,1,20)TIMESTAMP,status STATUS from all_objectswhere status not like 'VALID'order by owner,object_type,object_name/  

You may use
show error package(or whatever object which is invalid) object_name like
SQL> show error package BODY BMSBREV.COMMON_DMS  

Hope this will help  


Subject: utlrp and show errorsDate: Tue, 3 Jun 2008 14:47:07 -0500From: cjnewman_at_uillinois.eduTo:


When running utlrp to recompile invalid objects on, Solaris 64bit 8, it gives something similar to the below: …


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

Search that pays you back! Introducing Live Search cashback.
-- Received on Wed Jun 04 2008 - 08:41:35 CDT

Original text of this message