AreLOBs also backed up if I take a dump of all partitions of the table individually?

Question

I am taking export of a large table in oracle through datapump. I am taking the export of all the partitions one by one. The table has a LOB column as well. Are LOBs also backed up with partitions? Because partitions seem to be very small as compared to LOBs

Buffy Heaton · Accepted Answer

Yes, they should be. Unless, you have configured data pumps to exclude them somehow. Please share the command (and parameter file) that you use to make the data pump export. Reasons why the dump file is smaller could be that you have large areLOB indexes (which are not included, and should not be), or you are using compression.

AreLOBs also backed up if I take a dump of all partitions of the table individually?

About this question

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!