title: importing a dump file into oracle 11gr2 get errors
body: <p>While importing a dump file into oracle 11gr2 I am getting this error please suggest a way to resolve this</p>
  <pre><code>*Warning: the objects were exported by D7IDMP, not by you
  import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
  export client uses WE8ISO8859P1 character set (possible charset conversion)
  . importing D7IDMP's objects into MIGRATE
  . . importing table                    &quot;TXALLTXTS&quot;     245628 rows imported
  . . importing table                       &quot;TXAUTH&quot;        377 rows imported
  . . importing table                    &quot;TXBAIMERT&quot;        244 rows imported
  . . importing table                     &quot;TXBARESC&quot;        178 rows imported
  . . importing table                     &quot;TXBOILER&quot;     458940 rows imported
  . . importing table                    &quot;TXCLASSES&quot;        980 rows imported
  . . importing table              &quot;TXCLOSEDPERIODS&quot;          1 rows imported
  . . importing table                  &quot;TXCOMPANIES&quot;          1 rows imported
  . . importing table                 &quot;TXCONCLAUSES&quot;        187 rows imported
  IMP-00017: following statement failed with ORACLE error 959:
   &quot;CREATE TABLE &quot;TXCONFIGSETTINGS&quot; (&quot;CFS_CODE&quot; VARCHAR2(20), &quot;CFS_RCODE&quot; VARCHAR2(2&quot;
   &quot;0))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FR&quot;
   &quot;EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE &quot;MP5TEXT&quot; LOGGI&quot;
   &quot;NG NOCOMPRESS LOB (&quot;CFS_XMLCONFIG&quot;) STORE AS  (TABLESPACE &quot;MP5TEXT&quot; ENABLE &quot;
   &quot;STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE  STORAGE(INITIAL 65536 FREE&quot;
   &quot;LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))&quot;
  IMP-00003: ORACLE error 959 encountered
  ORA-00959: tablespace 'MP5TEXT' does not exist*
  </code></pre>
  <p>As per Alex comments, I tried with other attributes of imp but it resulted in someother error</p>
  <p>The command which I run is</p>
  <pre><code>imp fromuser=d7idmp touser=&amp;&amp;from_user file=test.dmp log= test.log ignore=y transport_tablespace = y tablespaces = MP5TEXT
  </code></pre>
  <p>the error is</p>
  <p>import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR
  character set export client uses WE8ISO8859P1 character set (possible
  charset conversion) IMP-00053: Import mode incompatible with Export
  dump file IMP-00000: Import terminated unsuccessfully</p>