It should work, you just need to give the connect string of the same db.
What name you give to dblink would be immatrial!
You can have multiple dblinks pointing to same db and can be itself also.
Uwe Schneider <uwe.schneider_at_xlink.net> wrote in message
news:3827FD12.9919AA5E_at_xlink.net...
> Hi experts,
>
> we have a problem with distrubuted databases/DB links:
>
> Former Situation:
>
> Application uses Instance "A" + read only data from instance "B". This
> was solved via a database link to "B".
>
>
> Situation now:
>
> Database "A" and "B" are both migrated to new instance "C".
> Application uses "C" (working). But since we do not want to rewrite the
> whole application NOT to use DB links we are trying to create a DB link
> on "C" called "B" pointing back to itself.
>
> How can this be done?
>
> Best regards
>
>
> --
> uwe.schneider_at_xlink.net
Received on Tue Nov 09 1999 - 06:48:07 CST
