Question Remote database operation
From: <sj_at_china.pages.com.cn>
Date: Sun, 31 May 1998 04:37:35 GMT
Message-ID: <6kqmqe$58l$1_at_nnrp1.dejanews.com>
Hello their :
Date: Sun, 31 May 1998 04:37:35 GMT
Message-ID: <6kqmqe$58l$1_at_nnrp1.dejanews.com>
Hello their :
I have post the question before and some friend do help me a lot .
But I still has problem with that.
The question is that:
- I create a database link from my orace server on sloaris to a Oracle server remotely on a HP UX .
I can access the remote database by using sqlplus like this :
sqlplus developer/developer_at_connect , where connect is the service name defined in my tnsnames.ora for another database But if I want to use the database link , There exist problem: if login local database by using sqlplus sj/sj133 I can not access the remote database by using the database link I create for remote database . It shows ORA-12666 . If I login local database using sqlnet , like sqlplus sj/sj133_at_oracle ( oracle is local database service name ) I can access database link easily . why ? 2. I define a trigger in local database for a table . the trigger act as the following : when a line is inserted into the table , the trigger is activated andtransfer the new line to remote database .
to get the target for this trigger , I met two problem :
the first : how to transfer the new line just inserted , because I can not use new and old variant in trigger because during inserting thetable is muting .
the second : how to deal with the communication default in trigger ? that is : when a new line is inserted into the database , if the communication line is cut down , just a ORA error message raised , the trigger did not go to the exception part , it just stoped ! can I deal with the problem like this in the trigger ?
I really appriciate any word about the problem .
Also , very thanks to peoples who have give me suggestion about the problem.
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 Sun May 31 1998 - 06:37:35 CEST