Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export image (LOB) to jpg files

647600Nov 4 2010 — edited Nov 4 2010

dear DBAs,

i'm working on a database 10g R2 where one of the tables, used by our application, is holding around 273000 records, and one image (in a LOB column) per record.
the image were migrated wrongly and the image size is greater than 200 KB.

the table size is too big now and i'm thinking about exporting these images, from the table, to multiple JPEG files (one file per photo) in order to run a tool to minimize the images quality/size and reload them back to the database.

can someone give an idea about a tool to export these images to files?

your help is highly appreciated.
Regards
Elie

This post has been answered by Saubhik on Nov 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2010

Added on Nov 4 2010

#general-database-discussions

7 comments

3,545 views