Differences

This shows you the differences between two versions of the page.

--- recompile_invalid_objects [2018/12/06 21:05] – created 91.177.234.129
+++ recompile_invalid_objects [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Recompile_invalid_objects ======
+  * Connect to an Oracle database as user //sys//
-*Connect to an Oracle database as user //sys//
+  * Check to see how many objects are invalid:
+<code>
-*Check to see how many objects are invalid:
  select count('e') from dba_objects where status='INVALID';
+</code>
-*Recompile all invalid objects:
+  * Recompile all invalid objects:
+<code>
  exec utl_recomp.recomp_serial();