How to Extract BLOB Data From Oracle Using Toad?

  • Post author:
  • Post category:Toad
  • Reading time:2 mins read

In this tutorial, you will learn how to extract BLOB data from Oracle using Toad. The following is an example suppose, you have a table in Oracle having BLOB data type column, and you want to export all the files stored in that BLOB data to a specific location using Toad.

Follow These Steps to Extract Files From BLOB Data in Oracle Using Toad

  1. In Toad for Oracle, click on the menu Database > Schema Browser.
  2. Then in the Tables tab, find your table containing BLOB data and click on it to select.
  3. On the right side, click on the Data tab, and it will show you the existing data.
  4. Then do the right click on the data grid and choose Export Blobs option.
  5. A window will appear as shown in below example. Select the BLOB column from the Export this column drop-down list. Then specify the export location in the Export Path field. Then select the radio button Export to files named for the value in this column (if the file names stored in a column), else choose sequentially numbered files option. Specify the file extension if a field for file names does not exist in the table. Now click on the OK button to export all the files from BLOB to the specified location.

export BLOB data from Oracle using Toad

You can check the export path location for the extracted files, as shown below.

extracted files from BLOB column in Oracle using Toad

See also:

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.

This Post Has 3 Comments

  1. Ichraf

    Hi, thank you for this. My Toad version is not allowing to select the gile extension. Still in the version 9. Do you know from which version that option is available ?
    Thank you !!

    1. Vinish Kapoor

      I have done this in version 9 only.

  2. CHARLES GERRITY

    I am trying to follow your instructions however, I do not have the option to Export BLOBS from the Toad menu (Right Click on data). Is there a specific version of Toad that needs to be used. (your procedure to export blobs also has issues with lines exceeding 32000 bytes)

Comments are closed.