title: Oracle Data Pump Export (expdp) locks table (or something similar)
body: <p>I must export data from a partitioned table with global index that must be online all the time, but I am having troubles in doing that.
  For data export I am using Data Pump Export - expdp and I am exporting only one partition. The oldest one, not the active one. </p>
  
  <p>My expdp command exports correct data and it looks like this:</p>
  
  <pre><code>expdp user/pass@SID DIRECTORY=EXP_DIR 
  DUMPFILE=part23.dmp TABLES=SCHEMA_NAME.TABLE_NAME:TABLE_PARTITION_23`
  </code></pre>
  
  <p>Application that uses database has a connection timeout of 10 seconds. This parameter can't be changed. If INSERT queries are not finished within 10 seconds, data is written to a backup file.</p>
  
  <p>My problem is that, during the export process that lasts few minutes, some data ends up in the backup file, and not in the database. I want to know why, and avoid it.</p>
  
  <p>Partitions are organized weekly, and I am keeping 4 partitions active (last 4 weeks). Every partition is up to 3 GB.</p>
  
  <p>I am using Oracle 11.2</p>