Question about database link

From: <sj_at_china.pages.com.cn>
Date: Thu, 28 May 1998 03:50:25 GMT
Message-ID: <6kimu1$lla$1@nnrp1.dejanews.com>

I am now trying to set up such a database exchange .

the following is the condition I am under :

my oracle listen to 202.96.98.24
the other oracle server is listen to 134.138.8.28

I have set up my Sun to be a part of 134.138.8.* (35) and config tnsnames.ora to set up a new entry to access the other database .

now , I can access the other database by using sqlplus like this:

sqlplus developer/developer_at_connect ( connect is a service name in

tnsnames.ora )

I think this means I can access the database at the other department.

so , I create a database link as following:

SQL>create database link db_link

     2  connect to  developer identified by  developer
     3  using 'connect.world';

Database link created .

SQL> commit;

Commit complete

SQL> select * from test_at_db_link

select * from test_at_db_link

ERROR at line 1:
ORA-12666: Message 12666 not found; product=RDBMS; facility=ORA

SQL> I can not find the error no in my messages book .

Also I met problem when create a trigger :

the following the trigger I created:

create or replace trigger go_other

AFTER insert on test1
for each row
begin
inser_to_dev;
end ;
/

create or replace procedure inser_to_dev as begin
insert into test
values ( 'data1' , 1, 'data2' );
exception

when others then

rollback ;

end;

well , I want to know how can I transfer the data just inserted into the table 'test1'( local ) to the remote database (named 'test') , I have tried to reference "new' , but there is always compile error .

How can I solve it ?

Thanks a lot .

Best regards

Jing Shen

Mail to : sj_at_china.pages.com.cn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 27 1998 - 22:50:25 CDT