在csdn上都没有找到解决的方法.

swswssw

多谢多谢,我先试试去。：）

玉面飞龙

http://download-west.oracle.com/ ... a96591/adl04mng.htm

LOB columns are subject to the following restrictions:

Distributed LOBs are not supported. Therefore, you cannot use a remote locator in SELECT or WHERE clauses of queries or in functions of the DBMS_LOB package.

The following syntax is not supported for LOBs:

SELECT lobcol FROM table1@remote_site;
INSERT INTO lobtable SELECT type1.lobattr FROM
    table1@remote_site;
SELECT DBMS_LOB.getlength(lobcol) FROM table1@remote_site;


(This statement produces error: ORA-22992 cannot use LOB locators selected from remote tables.)

However, you can use a remote locator in others parts of queries that reference LOBs. The following syntax is supported on remote LOB columns:

CREATE TABLE t AS SELECT * FROM table1@remote_site;
INSERT INTO t SELECT * FROM table1@remote_site;
UPDATE t SET lobcol = (SELECT lobcol FROM table1@remote_site);
INSERT INTO table1@remote_site ...
UPDATE table1@remote_site ...
DELETE FROM table1@remote_site ...


For the first three types of statement, which contain subqueries, only standalone LOB columns are allowed in the select list. SQL functions or DBMS_LOB APIs on LOBs are not supported. For example, the following statement is supported:

CREATE TABLE AS SELECT clob_col FROM tab@dbs2;


However, the following statement is not supported:

CREATE TABLE AS SELECT dbms_lob.substr(clob_col) from tab@dbs2;