RE: utlrp and show errors
- From: M Rafiq <rafiq9857@xxxxxxxxxxx>
- To: <cjnewman@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Jun 2008 09:41:35 -0400
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@xxxxxxxxxxxxxxx: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
