Hello there,

I am working on an Oracle 19c database and have encountered a problem while attempting to perform a Data Pump export of a particularly large schema.

The schema contains over 500 GB of data, mostly in LOB segments; and I am hitting a roadblock during the export process. The expdp job starts off fine, but after exporting several tables; the process slows down significantly and eventually hangs at certain points; especially when exporting tables with large LOB columns.

I have verified the disk space and ensured that the dump files are not hitting any space limits. The Data Pump directory has sufficient storage as well. No errors are thrown; but the log file shows that the export is stuck on tables with large LOB data Has anyone experienced similar issues with Data Pump exports involving large LOB data?

Also; I have gone through this post; http://forum.dbaclass.com/question/how-to-monitor-the-oracle-power-apps-db-that-oracle-is-installed-in-linux-machine/ which definitely helped me out a lot.

Could there be something I’m overlooking regarding Oracles handling of large LOB data during exports?

Thank you in advance for your help and assistance.