title: PLS-907 cannot load library unit
body: <p>Following is my oracle version
  Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production</p>
  
  <p>I was trying to alter a table to add a column but since it took long time, i cancelled it.</p>
  
  <p>After sometime, i started seeing errors in all packages and views that referenced the unit.
  Error message is </p>
  
  <blockquote>
    <p>PLS-907: cannot load library unit (table name)</p>
  </blockquote>
  
  <p>Googling on this error does not give much information. In one place, i saw that below command will help but it seems to me as very risky command</p>
  
  <blockquote>
    <p>alter system flush shared_pool</p>
  </blockquote>
  
  <p>Can anyone help me with the reason and solution to this?</p>
  
  <p>Thanks,
  Jeevan</p>