Re: HELP - Querying remote server

[Quoted] In article <8pt9of$m24$1_at_news.gte.com>,   remigius.muforo_at_telops.gte.com (Ramey Muforo) wrote:
> In Oracle 7.3
> I can do the following
>
> *from local server running oracle 7.3 and it works:
>
> select data1, data2, data3, data4
> from schema.table_at_tnsname;
>
> but I can not do the same from local server running oracle 8.1.6:
> I can login into the remote servers (7.3 and 8.0.5) successfully from
> local server running 8.1.6
> sqlplus name/password_at_name
> tnsping is OK
> Am I missing something or setting.
>
> Thanks in advance for your help.
>
> ramey Muforo
>
>

--
What kind of response *do* you get?  Error messages?  Do you get an ORA-
nnnnn message?

Ed Stevens
(Opinions are not necessarily those of my employer)


Sent via Deja.com http://www.deja.com/
Before you buy.