https://mailnest.com/dbawiki/index.php?action=history&feed=atom&title=Recompile_invalid_objects 2026-04-05T15:08:17Z Revision history for this page on the wiki MediaWiki 1.29.3 https://mailnest.com/dbawiki/index.php?title=Recompile_invalid_objects&diff=71&oldid=prev 2011-12-06T19:40:20Z

<p>‎<span dir="auto"><span class="autocomment">Recompile invalid objects</span></span></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 19:40, 6 December 2011</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">==Recompile invalid objects==</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*Connect to an Oracle database as user <ins class="diffchange diffchange-inline">&#039;&#039;</ins>sys<ins class="diffchange diffchange-inline">&#039;&#039;</ins></div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> </del></div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*Connect to an Oracle database as user sys</div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*Check to see how many objects are invalid:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>*Check to see how many objects are invalid:</div></td></tr> </table>

127.0.0.1 https://mailnest.com/dbawiki/index.php?title=Recompile_invalid_objects&diff=70&oldid=prev 2011-12-06T19:34:28Z

<p>Created page with &quot;==Recompile invalid objects== *Connect to an Oracle database as user sys *Check to see how many objects are invalid: select count(&#039;e&#039;) from dba_objects where status=&#039;INVALID...&quot;</p> <p><b>New page</b></p><div>==Recompile invalid objects==<br /> <br /> *Connect to an Oracle database as user sys<br /> <br /> *Check to see how many objects are invalid:<br /> select count(&#039;e&#039;) from dba_objects where status=&#039;INVALID&#039;;<br /> <br /> *Recompile all invalid objects:<br /> exec utl_recomp.recomp_serial();</div>

127.0.0.1