是否可以从远程Oracle数据库读取CLOB？ [英] Is it possible to read a CLOB from a remote Oracle database?

问题描述

此回答对SO的问题

...您可以从远程数据库读取LONG，但不能读取CLOB

... you can read a LONG from a remote database, but you can't read a CLOB

我没有在互联网上找到这个，是真的吗？

I did not find anything about this on the internet, is it true? Any documentation or citings for this will be helpful.

推荐答案

在某种情况下，答案是正确的，对于简单的select语句DB链接，您会收到此错误：

The answer is correct in a certain context, for simple select statements over a DB link, you'll get this error:

ORA-22992 ：无法使用从远程选择的LOB定位器表。

ORA-22992: cannot use LOB locators selected from remote tables.

从错误手册：

原因：无法引用远程LOB列。

操作：删除对远程表中LOB的引用。

Cause: A remote LOB column cannot be referenced.
Action: Remove references to LOBs in remote tables.

我也遇到了麻烦找到这个...的确定的文档，但我们刚刚遇到了同样的问题在我们的数据仓库。但是，有几种解决方法可供使用，拉取数据或创建视图。

I also had trouble finding definitive documentation on this...but we just ran into the same issue in our data warehouse. However, there are several work-arounds available, pulling the data over or creating a view for example.

这篇关于是否可以从远程Oracle数据库读取CLOB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！