Question about database link

From: <sj_at_china.pages.com.cn>
Date: Thu, 28 May 1998 03:49:58 GMT
Message-ID: <6kimt6$ldi$1@nnrp1.dejanews.com>

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

   the following is the condition I am under :

1. my oracle listen to 202.96.98.24
2. 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

-----== 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:49:58 CDT