Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBLink problem ORA-22992

398072Jul 28 2005 — edited May 11 2009
Hi all !!

I'm using an active dblink between db1 and db2 named orcl. Database db2 in schema usr has a couple of tables A and B looking like that:

Table A
column id number, primary key
column id_ref, number, not null,
column eventdate date not null
column longfield CLOB

Table B
column id_ref, number, primary key
column description varchar2(256) not null

In database db1 I ran the following query:

SELECT ID, ID_REF, EVENTDATE
FROM A@ORCL

and It works fine... But, If I try to run the following query:

SELECT A.ID, A.ID_REF, A.EVENDATE, B.DESCRIPTION
FROM A@ORCL A
INNER JOIN B@ORCL B
ON (A.ID_REF = B.ID_REF);

I get the following message:

ERROR in line 1:
ORA-22992: cannot use LOB locators selected from remote tables

db1 is an Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production running over solaris

db2 is an Oracle Database 10g Release 10.1.0.4.0 - 64bit Production With the Real Application Clusters option, running over solaris

How can I solve this problem ? Any help will be appreciated

Thanks in Advance

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 8 2009
Added on Jul 28 2005
5 comments
76,372 views