Re: Select Distinct over Database Link

From: Jayaraman Ashok <ashok_jayaraman_at_yahoo.com>
Date: 20 Aug 2002 17:44:08 -0700
Message-ID: <7ca2852.0208201644.1d41e987@posting.google.com>

Hi
Have you tried using the copy command ?

Ashok

Herman de Boer <h.de.boer_at_itcg.nl> wrote in message news:<ajti75$6ih$1_at_news1.xs4all.nl>...
> Gene Hubert wrote:
>
> >I've tried the DRIVING_SITE hint but to no effect. It acts like all
> >500 million records are going over the network to the database where I
> >am logged on.
> >
>
> Hello Gene,
>
> unfortunately, the driving_site hints seem to be ignored if used in a
> create-table-as-select, or an insert-select statement. There are some
> metalink / OTN hits, if one searches. Same behaviour even in 9.2.
>
> Workaround is to create a view on the remote site.
>
> Kind Regards,
>
> Herman de Boer
> sr consultant
> IT Consultancy Group bv
Received on Tue Aug 20 2002 - 19:44:08 CDT