title: Oracle: how to disable table compression on dmp file import
body: <p>I have dmp file that was created by EXP utility. The source database has table compression enabled.  How can I  disable compression while importing dmp file. The destination database does not have this future enabled. </p>
  
  <p>I can not find any switches on IMP  utility for this purpose. </p>
  
  <pre><code>imp u/p@sid file=test.dmp LOG=test.log  IGNORE=Y TABLES=(A_TABLE) FROMUSER=USR1 TOUSER=USR2
  </code></pre>
  
  <p>here is the error that I'm getting: </p>
  
  <pre><code>ORA-00439: feature not enabled: Table compression
  </code></pre>
  
  <p>Both databases are Oracle v 11g.</p>