Skip to Main Content
Forums

SQL & PL/SQL

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!

Access Blob Data from Table and save to Local file System

746342Jan 13 2010 — edited Jan 15 2010
I have a table which has a blob column in which most of the regular filetypes are uploaded and stored.

What is the best/easiest way to select/query this table and write all the blob contents into a local file system?

Am using oracle 10.2.

Is there a way of somehow batch processing and saving them to my local drive?

Any and all help is appreciated.

Thank you.
This post has been answered by Hoek on Jan 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2010
Added on Jan 13 2010
#blob, #data, #file, #to
6 comments
5,388 views