Re: database link

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: Fri, 10 Jul 1998 17:12:16 +0100
Message-ID: <6o5fbh$4gn$1@mendelevium.btinternet.com>

Try

Compute.world has to be in the names but it only has to be part of the name

create database link compute.world_at_link1 (link2 , link3...) connect to uname identified by pword
using 'TNS ENTRY for COMPUTE.WORLD';

Otherwise set global_names to false on the server if you dont need global names , or disable it when creating the link and then disable it on a per session basis if you can/want to

(alter session set global_names=false)

Regards

Adrian

hekenberg_at_my-dejanews.com wrote in message <6o55mt$3m5$1_at_nnrp1.dejanews.com>...
>Hello everybody,
>
>I'm working on OPENVMS 7.0 with an oracle server 7.3.2.3.0
>I want to create a database link to different databases. ( 7.1.5.3.0)
>
>The problem is that I have to databases which the global_name is
compute.world
>I can only create one database link because the name of the database link
must
>be compute.world
>
>What can I do ?
>
>Thanks
>Henrik
>Dba Oracle
>Paris - France
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Jul 10 1998 - 11:12:16 CDT