Skip to Main Content
Forums

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!

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
#11g, #database-key-features, #error, #oracle, #query, #replication
5 comments
76,391 views