Slow Export using DATAPUMP with BLOBS.
Posted on 2011-02-21
I am trying to export a schema that is 170GB. One of the tables in that schema is about 100GB, most of which is blobs.
When I do the whole schema, it takes about 7-8 hours to exports.
When I do a partial export by excluding the 100GB table, it takes 40 minutes.
I ran the segment advisor and shrank some tables, but that did not help either.
Is there any other way I can improve performance?
Oracle version is 10.2.0.5.0.