oracle 从表中导出 BLOB 图像
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/30271767/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Export a BLOB image from table
提问by Femme Fatale
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.
我在 Oracle 11G R2 中有一个表，名为 PERSON_IMAGE，带有 ID（数字）和 IMAGE(BLOB) 字段。现在不使用该应用程序，我需要导出多个 BLOB。我怎样才能做到这一点？我们有任何工具/实用程序吗？例子真的会帮助我。
回答by Béla
SQLDeveloper can do it:
SQLDeveloper 可以做到：
http://www.thatjeffsmith.com/archive/2014/05/exporting-multiple-blobs-with-oracle-sql-developer/
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.ldrrather than david.jpgbut it should be relatively straightforward to process the loader data file with a shell script if you want to rename them.
我只是在 4.0.3 版本中尝试过，虽然界面有点不直观，但它运行良好。我最终调用了很多文件TABLE64c49834-014d-1000-8494-c0a8b247f35d.ldr而不是，david.jpg但是如果要重命名它们，使用 shell 脚本处理加载程序数据文件应该相对简单。
