Re: Server to Server Communications

Arthur,

Yes you can get Oracle to insert the data into the second database using an Insert statement embedded in the trigger. On the source machine, you need to have the database alias in TNSNAMES.ORA and a database link created for the remote target. On the Target machine, you need to make sure that the LISTENER.ORA file is correct and running.

However, because the insert statement is in line with the transaction, you will be using Oracle's 2 Phase Commit (2PC and Distributed Transaction Option), which introduce some administrative issues for you. What happens when one of the machines crashed during the insert or commit statement.

Also, if you are using direct 2PC, then you need to remember that when the INSERT statement is issued and the Trigger fired on the source machine, the target machine MUST be online and operational. If the Target machine is down, then the trigger will fail and you won't be able to complete the transaction on the Source machine.

Hope this helps,
Andrew

Arthur Merar wrote:

> Hello,
>
> I have a project that needs to be completed by May 15th. Users will
> be updating some Oracle tables. Certain transactions will be stored
> in a seperate table. As these records are stored, I want a trigger to
> kick off and send these records to another Oracle table, on another
> server, elsewhere on the network. Can this be done?
>
> I do not know a lot about SQL Net. So, I do not know if there are any
> other files needed other than TSNAMES.ora and (I forgot the other
> filename).
>
> I need to know this stuff pretty quick. Please send your response to
> my e-mail.
>
> Thanks,
>
> Arthur
> amerar_at_unsu.com
Received on Tue Apr 20 1999 - 20:43:56 CDT