title: Script to check to Invalid objects in Oracle and build script to compile the invalid objects
body: <p>In Oracle DB, in some instances the objects (Views/Synonyms) are getting 'Invalid' (Out of compile) which is adding more work to me to maintain these issues frequently.</p>
  
  <p>I'm planning to include some statements in the initial and end of my script in my every deployment 
  1. To check all invalid objects before my changes are deployed.
  2. After the changes get deployed check all the invalid objects again and build  a script automatically to fix the INVALID views &amp; synonyms and execute it.</p>
  
  <p>It would be of great help to me if anyone can help me in building a oracle script which covers my above mentioned points?</p>
  
  <p>NOTE: I don't have the DBA ADMIN access, I use deployment tool to deploy the scripts</p>
  
  <p>Thanks a lot in advance.
  Sitesh</p>