CODEWITHSUNDEEP
oracle-databaseoracle11gbloboracle-sqldeveloper
Femme Fatale
Femme Fatale

Reputation: 880

Export a BLOB image from table

I have table in Oracle 11G R2, named as PERSON_IMAGE with ID (Number) and IMAGE(BLOB) fields. Now without using the application i need to export multiple BLOBs. How can i do this? Do we have any tool/ utility for this? Example will really assist me.

Upvotes: 2

Views: 17684

Answers (1)

Béla
Béla

Reputation: 284

SQLDeveloper can do it:

http://www.thatjeffsmith.com/archive/2014/05/exporting-multiple-blobs-with-oracle-sql-developer/

I just tried it in version 4.0.3 and although the interface was a little unintuitive, it worked fine. I ended up with a lot of files called TABLE64c49834-014d-1000-8494-c0a8b247f35d.ldr rather than david.jpg but it should be relatively straightforward to process the loader data file with a shell script if you want to rename them.

Upvotes: 3

Related Questions