RE: utlrp and show errors

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

Chris,  

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  

Regards
Rafiq  

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

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

---

Search that pays you back! Introducing Live Search cashback. http://search.live.com/cashback/?&pkw=form=MIJAAF/publ=HMTGL/crea=srchpaysyouback
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 04 2008 - 08:41:35 CDT