Question Remote database operation

From: <sj_at_china.pages.com.cn>
Date: Sun, 31 May 1998 04:37:00 GMT
Message-ID: <6kqmpd$576$1@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 and

transfer 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 the

table 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 Sat May 30 1998 - 23:37:00 CDT