----------------------------------- -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);
Monday, September 16, 2013
Invalid objects in Database
Subscribe to:
Post Comments (Atom)
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...
-
I got a task to estimate RMAN backup size. How much 3days RMAN backup occupy? How long it will take to complete? Is the backup siz...
-
I got the below issue while Cloning ORACLE HOME from source to target. I have copied the binaries from source and initiated adcfclone. It ...
-
We have received an alert in the morning that the Primary Database is out of Sync. Primary and Standby are with difference of 9 archives. ...
No comments:
Post a Comment