Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Invalid Objects after Recent Patching

edited May 28, 2012 9:30AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 comment
After a recent patch application, it is found that there are still a large number of Invalid Objects on the instance.

Executed following script to identify the invalids:

  column owner format A9
  column object_name format A31
  column object_type format A15
  column last_ddl_time format A10
  spool invalids.lst
  select OWNER, OBJECT_NAME,OBJECT_TYPE,STATUS,LAST_DDL_TIME
  from dba_objects where status='INVALID'
  order by owner;
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center