How do I export BLOBs (.JPGs) from Oracle 9i into individual .JPG files?

Hello,

I have a database with 2029 images stored in it.  The problem with just moving them from one database to another is I need to go through an enrollment process with them so I need the individual files.  I cannot simply migrate the data.

I have been using OraLOB Editor to save them individually.... but it is taking way too long.  I need this done ASAP.

In the table with the BLOBs there is also a column for original filename.  Is there a way to grab the image, assign the name from the 'IMAGE NAME' field of the corresponding record and save it to disk?
emoshagAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
actonwangCommented:
you could use:

(1). UTL_FILE (UTL_FILE.PUT_RAW) combined with DBMS_LOB package to write blob data into a file (in the server side).

(2) use java (blob data stream) to write it to local file.

see examples in the above link.

acton
0
 
actonwangConnect With a Mentor Commented:
0
 
sathyagiriConnect With a Mentor Commented:
Check this one , they have a sample program

http://www.freelists.org/archives/oracle-l/02-2004/msg02636.html
0
All Courses

From novice to tech pro — start learning today.