How to Take Backup of LOB in Oracle Export

To take backup of lob in oracle export, first, you need download and install DBBlobEditor.

Run DBBlobEditor.

To take backup of lob in oracle export, click ‘Tools->Export LOB’, LOB export form is displayed, you can export lob data from a table:

backup oracle lob from table

or a query:

backup oracle lob from query

And you can restore your LOB data, click ‘Tools->Import LOB’, LOB import form is displayed:

Oracle LOB Editor - restore oracle lob

DBBlobEditor is a database tool that helps DBA and Database Programmer edit Oracle LOB (BLOB, CLOB) data directly.

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.


Posted

in

by