Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance DB-Link
triggers are executed on the node where the table lives
(otherwise oracle would have to move the code to the controlling node and
reverse engineer it to include the DB link in all the table references in
the trigger)
"Arne Bippes" <sceddie_at_gmx.de> wrote in message
news:ddad38c.0310310514.3cd04e38_at_posting.google.com...
> Thanks for your answears. I guess I won't have a Problem since I'm not
> using Joints. Or at least not more than using mqseries.
> Actually all i do is get all entrys with status X on the local table,
> insert it in the remote table and update the status in the local table
> using the return code.
>
> Just one further question. I have a very complex Trigger on the
> Remote-Table (the trigger does several checks and returns a status).
> Will the trigger be executed on the Remote machine and hopefully not
> on the local machine ?
>
> Greetings from Germany
>
> Arne Bippes
Received on Fri Oct 31 2003 - 07:57:30 CST