Re: HELP - Querying remote server

Hi Muforo,

you have to do an

create database link <LINK_NAME> connect to <USER_NAME> identified by <PASSWORD> using '<LINK_NAME>';

select * from <TABLE_NAME>_at_<LINK_NAME>;

i believe your <LINK_NAME> is 'name';

evtl use 'name.world' as your <LINK_NAME>.

Best regards,

Toni

 In article <8pt9of$m24$1_at_news.gte.com>, Ramey Muforo <remigius.muforo_at_telops.gte.com> 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
 

-- 
Click here to stop the internet: [Shutdown WWW]
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner