How do I export BLOBs (.JPGs) from Oracle 9i into individual .JPG files?
Posted on 2006-07-07
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?