Hai everybody.
I have tried by creating dblinks on two databases pointing to eachother. I created one table each on each database with same names test1. Please see the following:

SQL>create user test1 identified by test1;

SQL>grant connect, resource to test1;

SQL>alter user test1 default tablespace users;

SQL>conn test1/test1

SQL>create sequence photonum;

SQL>create table photoalbm (photoid number(5), photo blob);

SQL>create or replace trigger photoid
before insert on photoalbm
for each row
begin
select photonum.nextval into :new.photoid from dual;
end;
/

SQL>create view v_photoalbm
as select photoid, dbms_lob.getlength(photo) photo from photoalbm;

SQL>create database link testlk
connect to test1 identified by test1
using 'INTDAG';

SQL> select photoid, dbms_lob.getlength(photo)
from photoalbm@testlk;
select photoid, dbms_lob.getlength(photo)
*
ERROR at line 1:
ORA-22992: cannot use LOB locators selected from remote tables

Now, I tried using the view instead of table directly.

SQL> insert into photoalbm
select * from v_photoalbm@testlk;
2 select * from v_photoalbm@testlk
*
ERROR at line 2:
ORA-00942: table or view does not exist
ORA-02063: preceding line from TESTLK

Again I tried using the table name:

SQL> insert into photoalbm
select * from photoalbm@testlk;

0 rows created.


Nothing works. I created a view and tried to access the view instead of table according to one of the Asktom post.....

Please let me know........

regards,
Dileep Tallam.