Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: insert data from other instance
You're in need of replication. It is available only in the enterprise edition but it does exactly what you require. It comes with maintenance baggage but fulfills your requirements. Joe B>
<suberbie_at_my-deja.com> wrote in message news:9425pk$4vi$1_at_nnrp1.deja.com...
> I have 2 instaces "A" and "B"
>
> In the instance "A" I have a table TABLE_A and in the instace "B" the
> table TABLE_B.
>
> I need to put a trigger that when I insert data in TABLE_A the event
> executes "something" (store procedure) and insert data in the
> instance "B" in the table TABLE_B
>
> Another information: TABLE_A is diferent from TABLE_B , this produce
> that I need to manipulate info in the store procedure triggred and put
> some values in hardcode or from another tables.
>
> I have Oracle 8i and I need an example code if it is posible
>
> Thanks
> Suber
>
>
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 17 2001 - 05:35:57 CST