How to Take Backup of LOB in Oracle Export

by

Posted on by

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.