Re: Newbie - How can I reference to a table using a synonyms via a dblink to a remote server ?

Kenny Lim schrieb in Nachricht
<7kfc88$d23$1_at_birch.prod.itd.earthlink.net>...
>Hi Guys,
>
>I am experimenting in how to query a table using a synonyms via dblink
>referencing to a remote server.
>
>First I created a simple table in instance "A"
>Then I created a dblink and synonyms referencing to the table in instance
>"B"
>Upon creating the neccesaries, I try to perform a query against the
synonyms
>in instance "B",
>
>I received the following error messages :
>
>ORA-02085: database link name connects to name
>

I think, I had the same error message some weeks ago. The cause could be the parameter "global_names" in the INIT<SID>.ORA.

Try :
a) open INIT<SID>.ORA (Path should be %ORACLE_HOME%/DATABASE) b) look for the parameter global_name and change it's value to :

    global_name=false
    If you don't see the parameter then insert the line. c) shutdown the database und startup again d) test your statement

I'm not quite sure, but I think you have to do this for "instance A".

Hope it helps

Peter Received on Thu Jun 24 1999 - 15:53:15 CDT