title: Export an Oracle database, import it to a different user, stored procedures don't work
body: <p>I export an oracle "schema" using </p>
  
  <pre><code>exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y
  </code></pre>
  
  <p>and then import it into a different schema on the same oracle instance on the same SID using </p>
  
  <pre><code>imp userid=/ file=pt.dmp fromuser=FOO touser=paul
  </code></pre>
  
  <p>When I try to access the stored procedures with the new user, I get </p>
  
  <pre><code>ORA-29541: class PAUL.ESMQOracleStoredProc could not be resolved
  </code></pre>
  
  <p>Any idea why one user can resolve this but another one can't?</p>