从表中导出BLOB图像 [英] Export a BLOB image from table

问题描述

我在Oracle 11G R2中有一个表，名为ID(数字)和IMAGE(BLOB)字段的名称为PERSON_IMAGE.现在，不使用应用程序，我需要导出多个BLOB. 我怎样才能做到这一点?我们为此有任何工具/实用程序吗? 例子确实可以帮助我.

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.

推荐答案

SQLDeveloper可以做到:

SQLDeveloper can do it:

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

我只是在4.0.3版本中尝试过，尽管该界面有点不直观，但效果很好.我最终得到了很多名为TABLE64c49834-014d-1000-8494-c0a8b247f35d.ldr而不是david.jpg的文件，但是如果要重命名它们，使用shell脚本处理加载程序数据文件应该相对简单.

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.

这篇关于从表中导出BLOB图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！