Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Distinct over Database Link
Oh, well...I guess a view on the remote server is the way to go..
gwhubert_at_hotmail.com (Gene Hubert) wrote:
>TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<ldh7mu8rucjmo9jfqbcio4ujc74hgaa7lc_at_4ax.com>...
>> Just 1 additional try:
>>
>> Have you tried
>>
>> Insert into mylocaltable
>> Select mykey from ( select distinct mykey from monster_at_mydblink );
>>
>>
>> This should push the distinct to the remote server and just return the subset..
>>
>
>That's a clever thought but it doesn't do it. The remote db query is:
>select mykey from monster;
>
>Gene Hubert
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Aug 22 2002 - 09:40:47 CDT