> 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. -- //www.freelists.org/webpage/oracle-l