Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Recompiling invalid objects with a batch file

Recompiling invalid objects with a batch file

From: Ubiquitous <weberm_at_polaris.net>
Date: Wed, 05 Dec 2007 00:24:04 -0500
Message-ID: <MbadneoufO_fq8vanZ2dnUVZ_rfinZ2d@giganews.com> 





Is there a way to write a sqlplus batch file to "recompile all invalid
objects", or at least compile a specific object? I know the capacity 
exists in TOAD but I have no idea what's going on behind the scenes...



Thanks!
Received on Tue Dec 04 2007 - 23:24:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US