Monday, September 16, 2013

Invalid objects in Database

-----------------------------------
-This script is used to check the invalids
- Script Name : invalids.sql
- Usage : @invalids
----------------------------------
SET PAGESIZE 300
SET LINESIZE 150
col OWNER for a25
col OBJECT_NAME for a30
select OWNER,OBJECT_TYPE, STATUS,count(*)
from dba_objects where STATUS='INVALID' group by OWNER,OBJECT_TYPE, STATUS order by owner
/

select count(*) from dba_objects where STATUS='INVALID'
/
prompt Suggestion : @?/rdbms/admin/utlrp.sql

-------------------
backup for patching
-------------------
create table p&patchno as(select *from dba_objects where status='INVALID');

------------------------------
Use below query after patching
------------------------------
select count(*) from dba_objects where status='INVALID' and object_name not in(select object_name from &backup_table);

No comments:

Post a Comment

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...