title: Data pump "impdp" fails with error message saying "unable to extend the table"
body: <p><strong>Background</strong></p>
  <p>I am trying to import a huge Oracle database dump whose size is larger than 40GB to my Oracle Express environment. As you know, Oracle Express does allow only up to database size of 11GB. Therefore, I can't &quot;impdp&quot; the entire bulk of this dump file to my Oracle XE. I need to <em>selectively import only some tables</em> which won't exceed the XE limitation.</p>
  <p><strong>Preparation</strong></p>
  <p>I created tablespaces required for the import which point to a directory <code>DIR</code> on my harddrive as follows:</p>
  <blockquote>
  <p>Directory object {<strong>DIR</strong>} created as <strong>/db/</strong></p>
  <p>Tablespace <strong>ABC</strong> is created at <strong>/db/abc.dbf</strong> allocated a size of 6GB</p>
  <p>I created the tablespace with only size applied, no other additional arguments.</p>
  </blockquote>
  <p>Hint*: Tablespace name ABC is required by the dump file for import.</p>
  <p><strong>I successfully imported the entire database structure</strong></p>
  <p>First of all, I ran this command below to create table structures in my target XE environment without copying any data. Just to make sure my dump file contains all tables I want:</p>
  <pre><code>$&gt; impdp system/pwd directory=DIR dumpfile=FOO.dump 
     content=METADATA_ONLY schemas=FOO;
  </code></pre>
  <p>The command above is executed correctly. All table structures are created in my XE environment under schema <code>FOO</code>.</p>
  <p><strong>Next, I want to start importing table data (BUT FAILED)</strong></p>
  <p>Then I start off with the first table to import, say table <code>abc</code>. I ran this command to import only data to my pre-created table.</p>
  <pre><code>$&gt; impdp FOO/pwd directory=DIR dumpfile=FOO.dump
     content=DATA_ONLY tables=abc;
  </code></pre>
  <p>You may notice I switch from the user <code>system</code> to <code>FOO</code>. I'm aware of this. Due to the fact that my tables are created under schema <code>FOO</code>, so I use <code>FOO</code> to import it to the existing tables under this schema.</p>
  <p>However, this fails. I've got errors as shown below:</p>
  <blockquote>
  <p>Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production</p>
  <p>Master table &quot;FOO&quot;.&quot;SYS_IMPORT_TABLE_01&quot; successfully loaded/unloaded</p>
  <p>Starting &quot;FOO&quot;.&quot;SYS_IMPORT_TABLE_01&quot;:  FOO/******** directory=DIR dumpfile=DUMP.dump logfile=import_table.log content=data_only tables=item_keyword_tab</p>
  <p>Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA</p>
  <p>ORA-31693: Table data object &quot;FOO&quot;.&quot;ABC&quot; failed to load/unload and is being skipped due to error:</p>
  <p><strong>ORA-29913: error in executing ODCIEXTTABLEFETCH callout</strong></p>
  <p><strong>ORA-01653: unable to extend table FOO.ABC by 8 in tablespace ABC</strong></p>
  <p>Job &quot;ABC&quot;.&quot;SYS_IMPORT_TABLE_01&quot; completed with 1 error(s) at 02:03:33</p>
  </blockquote>
  <p>The error message seems to mention &quot;the tablespace cannot be extended by only 8 MB&quot;. I can guarantee I have created the sufficient tablespace &quot;ABC&quot; which is as large as 6 GB and it won't exceed the XE limitation.</p>
  <p>Can anybody please help me figure this out? How should I do?</p>
  <p>My assumptions are:</p>
  <ul>
  <li><p>The schema &quot;FOO&quot; is lack of privilege so it cannot extend the table while importing. I explored the documentation but &quot;extending the tablespace&quot; is not one of the adjustable privilege of users.</p>
  </li>
  <li><p>Extending the tablespace by 8 MB is very small in size. I don't think this is a true reason why it fails. There might be other underlying cause.</p>
  </li>
  </ul>