export and import only selected column from a table
Oracle 11.1.0.7:
Is there a way to only export and import selected columns instead of all the columns using datapump, expdb/impdb? We have 4 TB database and we need to export and import the entire DB to a new DB except the BLOB columns. I couldn't see any way of doing this in expdb. Are there any other options? Obviously, we want the export and import to take as less of time as possible.