Quote Originally Posted by thomgreen
I thought that it might be a permissions issue but I can access all tables through the dblink from db2. Is there any specifics about that particular table that would not allow me to select from db3?
Hmm, that was my first thought as well. But, since you're connecting directly to the user on db1 (IMHO, a big no-no, but that's besides the point) I don't think that's it. To verify, login directly to db1 and see if you can get to the table.

My second thought would be to verify that there are not more than one dblink with the same name; one public and one private.

My third thought would be to verify that the tnsnames.ora point to the same place.

My fourth thought would be to check synonyms and the like, but only as a last resort.