Re: help on database link needed

Or the database test2 may be the result of a clone of test.

To test to see what it is:

select * from global_name;

To change, try:

alter database rename global_name to TEST2;

    HTH,     Jon

Bill Manry wrote in message <356e371d.270896278_at_newshost.us.oracle.com>...
>On Thu, 28 May 1998 14:13:03 +0200, Harald Stefan <stefan_at_grandel.de>
>wrote:
>> 5. the create of the link is ok, but when i adress the database link
>> test_2 with "desc tabelle_at_test_2" the message appears:
>> "database link test_2 connects to test"
>
>In the init.ora file for SID1 change the GLOBAL_NAMES parameter to
>FALSE or remove the setting (it defaults to FALSE). Having it set to
>TRUE enforces a requirement for dblink names to match the target
>database name.
>
>----------
>Bill Manry - IBM Products Division - Oracle Corp. USA
>These are my opinions, not Oracle's.
Received on Sat May 30 1998 - 00:43:57 CDT