title: How to SELECT in Oracle using a DBLINK located in a different schema?
body: <p>We have an Oracle DBMS (11g) and the following configuration:</p>
  
  <ul>
  <li>A DB user "MYUSER"</li>
  <li>Two schemas "MYUSER" and "SCHEMA_B"</li>
  <li>User "MYUSER" can access "SCHEMA_B" and has READ permissions on its tables</li>
  <li>A public DB link "DB_LINK" located in "SCHEMA_B"</li>
  <li>The DB_LINK is working when using the DB user "SCHEMA_B" directly</li>
  </ul>
  
  <p><strong>Question</strong>: When logged on as "MYUSER", what is the correct syntax to access tables using the DB link of "SCHEMA_B"? Is it possible to do so at all?</p>
  
  <p>I already tried several constellations, which all did not work:</p>
  
  <pre><code>select * from dual@"DB_LINK"
  select * from dual@"SCHEMA_B"."DB_LINK"
  select * from dual@SCHEMA_B."DB_LINK"
  select * from dual@SCHEMA_B.DB_LINK
  select * from SCHEMA_B.dual@DB_LINK
  select * from "SCHEMA_B".dual@DB_LINK
  </code></pre>
  
  <p>The error message I receive is:
  ORA-02019. 00000 -  "connection description for remote database not found"</p>
  
  <p>Thanks for any suggestion!</p>