How to exlude LOB types from data pump export
Hi,
I have a 1.5TB database ver. 11.2.0.3 and I have to export all data exclude four tables that contain LOB columns.
The size of four tables in total is about 1.2GB. I tried to exclude these tables but the total estimated size is 1469GB (calculated in the beginning of expdp running)
The four tables that contain the LOB type are in the same schema.
expdp system/xxx directory=export_dir parfile=Z:\Export\export_parameters.par
export_parameters.par:
full=yes
exclude=table:"IN('schema.table_name','schema.table_name','schema.table_name','schema.table_name')"
dumpfile=yyy_%U.dmp