Re: Connecting to a remote db which has no domain name, but local db has global_names=true

Rob Cowell wrote:
> I can't find anywhere that shows this is possible, but I'll ask just
> incase someone has a whizzy workaround.
>
> I have a 9.2.0.6 database with global_names=true, because we use
> streams and multimaster replication, and they seem to like that.
>
> I want to connect to a remote 9.2.0.6 database which has no domain
> name.
>
> When I create a dblink with the full db name of the remote db it gets
> the domain name from my db appended to it.
>
> All the "solutions" I can find for this involve either setting
> global_names=false, which I could do at a session level for the queries
> that use this dblink, probably via a logon trigger cos the app logs on
> all over the place.
>
> Or I could get a domain name on the remote db. But that's owned by
> another company and they're doing us a favour letting us connect and
> its a pain getting any changes on their db.
>
> But is it possible to create a dblink without turning off global_names
> that will connect to a remote db without a domain_name ?
>
> Thanks

There's a concept of database link qualifier. Note:1024124.6 talks about it. But it doesn't work for me.

Yong Huang Received on Tue Jun 13 2006 - 23:23:42 CDT