Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL on multiple databases/users
"Emo Ludovic" <emo_ludovic_at_caramail.com> wrote in message
news:a653a553.0212240358.3ba8e2ca_at_posting.google.com...
> Hello,
>
> I have 5 users having the same schema (same tables, same constraints, ...)
> not on the same physical server.
>
> I need to synchronize some content (some lines of some tables) between
> thoses users, with some handling on the datas (recalculate ids, ...)
>
> Do you know if in PL/SQL, I can read datas on one of the user
> and alter (insert/update/delete) on another user consequently
>
> I mean having two connections on two servers/databases/users opened at
> the same time.
>
> Thanks in advance.
Yes. Connect as the target (insert/update/delete) user, then make a cursor
like this:
cursor cur_something is
select fields from table_at_remote;
You only have one connection - the target user. The 'remote' is a database link to the source user. Received on Tue Dec 24 2002 - 11:29:18 CST
![]() |
![]() |