Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL on multiple databases/users

Re: PL/SQL on multiple databases/users

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 24 Dec 2002 17:29:18 GMT
Message-ID: <OP0O9.63350$vb3.2539033@news2.west.cox.net>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US