Re: how to query between 2 remote databases

The error I get is:

SQL> !oerr ora 00933
00933, 00000, "SQL command not properly ended"

The OS is HP/UX 9000

TurkBear wrote:
> "kiran" <kiran.news.invalid_at_web2news.net> wrote:
>
>>How to query on two tables that are on two different remote database
>>with a join.
>>
>> s *
>> f tb1_at_uid/pass_at_db1.world a, tb2_at_uid/pass_at_db2.world b
>> w a.col1 = b.col2
>>
>>but this does not work, any idea ?
>>
>>Thanks
> Does not work, how?
>
> Also OS, version, etc would be a nice touch..

-- 
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.oracle.server