How To Export a Table Without Blob Column in Oracle

It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with DataPump export to export a table without blob data.

To use REMAP_DATA, you first need a function to change the data.

You can create the required function as follows. The function will be created in a package.

We can then use this function with the REMAP_DATA feature during export.

In the example below, the blob column named blon_test of the test_lob table is modified and the expdp command is specified for export. The user to execute the expdp command must have execute permission for the function we have created above.