Re: Problems when using distributed SQL??

At 12:11 AM 1/3/96 GMT, cme_at_magnet.at wrote:
>
>- Maybe you forgot to grant select privileges on table2.
> "GRANT SELECT ON TABLE2 TO PUBLIC"
>- If this doesnt help check your SQL*NET configuration files.
> Make sure you can connect to the remote machine via sqlplus.
> It looks that you are using SQL*NET V1.xx.
> If possible use SQL*NET V2.xx. Networking is much easier than.
>- The distributed Option is a separately priced product. If it is installed
>then sqlplus should come up with:
>" ORACLE 7.xxx .......Server Production Release with the
>distributed option installed"
>
>cme_at_magnet.at
>Vienna/Austria/Europe
>
>

Thank you very much for your help, but my problem was resolved when I set GLOBAL_NAMES=FALSE. Every thing after that worked just fine.

Thanks for those who sent me notes with this answer.

Al Sabawi, P.Eng.                         Internet:sabawi_at_ibm.net
Toronto, Ontario -- CANADA                 Client/Server Database 

• Internet Message Header Follows --- Received: from smtp-gw01.ny.us.ibm.net ([165.87.194.252]) by mail.magnet.at with SMTP id AA28944 (5.67b/IDA-1.5); Wed, 3 Jan 1996 03:51:57 +0100 Received: (from uucp_at_localhost) by smtp-gw01.ny.us.ibm.net (8.6.9/8.6.9) id CAA33709; Wed, 3 Jan 1996 02:44:47 GMT Date: Wed, 3 Jan 1996 02:44:47 GMT Message-Id: <199601030244.CAA33709_at_smtp-gw01.ny.us.ibm.net> Received: from slip153-72.on.ca.ibm.net(129.37.153.72) by smtp-gw01.ny.us.ibm.net via smap (V1.3mjr) id smaMowDM2; Wed Jan 3 02:44:37 1996 X-Sender: sabawi_at_pop01.ny.us.ibm.net Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: cme_at_magnet.at, comp.databases.oracle_at_magnet.at, sabawi_at_ibm.net From: sabawi_at_ibm.net (Al Sabawi) Subject: Re: Problems when using distributed SQL?? X-Mailer: <Windows Eudora Version 1.4.2b16>