emoshag
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(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