Re: Retrieving a set of randomly chosen records (Oracle 9i)

"andreas.krisor_at_gmx.net" <andreas.krisor_at_gmx.net> wrote in news:1108737915.215801.132860_at_f14g2000cwb.googlegroups.com:

> Hi David,
>
> thank you for this hint, it works partly:
>
> my SELECT-statements refer to tables via a db-link and using SAMPLE
> results in an error.
>
> Do you know how I can use SAMPLE with db-links?
>

I can't say that I've tried this, but does it work to create a VIEW in the remote DB which contains the SAMPLE clause?

SELECT * FROM REMOTE_VIEW_at_OTHER_DB; Received on Fri Feb 18 2005 - 09:48:43 CST