invalid objects running utlu11i.sql
oracle support strongly recommends that I perform an out of place upgrade from 11.1 to 11.3
first step is to run utlu11i.sql and resolve issues.
I've got everything resolved except for 2 issues:
1. stale optimizer stats
2. invalid objects
for the stats I ran DBMS_STATS.GATHER_DICTIONARY_STATS and DBMS_STATS_GATHER_SCHEMA_STATS for the 2 schemas shown with stale stats: SYS and SYSMAN
However, after running, upon re-running utlu11i.sql the stats were still classed as stale.
Question- what did I do wrong and how important is this?
Mike
for invalid objects when I look at schemas that have invalid objects using Toad I was able to resolve (recompile) all except WKSYS,WMSYS, PUBLIC and PERFSTAT
0