How to Extract BLOB Data From Oracle Using Toad?

How to Extract BLOB Data From Oracle Using Toad?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 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:

This Post Has 3 Comments

  1. Ichraf November 1, 2020

    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 November 2, 2020

      I have done this in version 9 only.

  2. CHARLES GERRITY April 24, 2021

    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.