Question about database link
Date: Thu, 28 May 1998 03:52:54 GMT
Message-ID: <6kin2m$ln8$1_at_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 Thu May 28 1998 - 05:52:54 CEST