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.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *