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

449    Asked by BuffyHeaton in Salesforce , Asked on Mar 7, 2023

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

Answered by Camellia Kleiber

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.



Your Answer

Interviews

Parent Categories