Okay, thanks for all your input guys and gals.
Since I already have a table which holds the server id, and dblink,
and is identical across all sites, I am going to create a local view at each
of the sites which will only contain the id of the local server.
Karen Abgarian wrote in message <37D91462.399B38AA_at_fmr.com>...
>If you need to choose a database link, why dont you simply pick it from
>USER_DB_LINKS? This view shows the links outcoming from your server.
>You can create private links in schemas on both servers.
>
>Regards,
>Karen Abgarian.
>
>Keith Jamieson wrote:
>
>> I have data on server A which needs to be copied to server B.
>> I have data on server B which needs to be copied to server A.
>>
>> The data will be copied using the same stored procedure
>> which will reside on both server A and server B, only the direction of
the
>> copy will change.
>>
>> If I am on server A I need to use dblink_to_b.
>> and if I am on server B I need to use dblink_to_a.
>>
>> Is there anyway (say from the system catalogs, etc, I can find out which
>> server the procedure is running from.
>>
>> If I know this, then I can append the appropriate dblink to the procedure
>> using dynamic pl/sql.
>
>
>
Received on Mon Sep 13 1999 - 03:02:10 CDT
