Nulling a BLOB column in Oracle 11 impdp I need to import a 50 GB dump file containing three schemas. Over 90% of the file is taken up by a single BLOB column. How could I import the schemas, including the table containing the blobs, but replacing the values in the column with nulls? I could do a full import, null the column manually, do an export, delete the schemas and do a new import, but is there away to exclude a single column's data with impdp parameters?
Another option would be to do a datapump export of a view that has only the columns and data that you want. If you want a column to be null have the view make the column null. Then when you do the import you are only importing the data that you want.

expdp VIEWS_AS_TABLES