title: What's the difference between compiling and refreshing a materialized view?
body: <p>We just ran into a problem where materialized views weren't refreshing, and giving a compile error. One of the senior developers says he just figured out how to fix it -- by telling toad to compile the materialized view.</p>
  
  <p>So my question is pretty simple: what's the difference between a refresh and a "compile"?</p>