title: Challenge in Migrating Huge Table with LOB Data
body: <p>We're trying to migrate around 230 GB Oracle EC2 hosted Database into RDS. The challenge with the DB is that there is one 150GB table which has lot of LOB data. When we try to migrate with data using Oracle Import/Export (Data Pump) it takes around 9.5hrs to export the 150 GB table and which has LOB data and 2hrs to import the dump into RDS whereas other tables migrated fairly quickly. We're using instance with highest configurations but still don't see any improvement in performance. </p>
  
  <p>Just to see the time difference exported the 150GB dump again on EC2 and in second run it took only 3hrs time. Could someone please suggest me a better approach to reduce the export/import time. </p>
  
  <p>PS: We also tried to use RedGate tool to identify schema and data differences between Oracle databases but this tool also failed to perform comparison on Huge LOB tables. </p>