Re: DB Links

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 23 Sep 2004 22:33:39 +0300
Message-ID: <239401c4a1a4$3a6d3300$b9f823d5@porgand>

> possible to filter remotely? Very simple, create a remote view, and
> access the view instead of the tables. I find that method to be much more
> portable and version independent then hints. Did I mention that I
> strongly dislike hints?

Also, when accessing a remote view instead of multiple remote tables, you will save several sqlnet roundtrips over dblink which are probably used for describe operation for remote tables...

Tanel.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 23 2004 - 14:29:34 CDT