title: Query two tables from different schema
body: <p>I have two different schemas in Oracle (say S1, S2) and two tables in those schemas (say S1.Table1, S2.Table2). I want to query these two tables from schema S1.</p>
  
  <p>Both S1 and S2 are in different databases. From DB1 - Schema S1, I want to do something like this,</p>
  
  <pre><code>select T1.Id
    from S1.Table1 T1
       , S2.Table2 T2 
   Where T1.Id = T2.refId
  </code></pre>
  
  <p>I know one way of doing this would be to create a DB Link for the second schema and use it in the query. Sadly, I don't have the privileges necessary to create a DB link. Is there some way to do this without DB link? For example, in TOAD you can compare two schema objects. But again, two schema objects and it is general comparison.</p>
  
  <p>Any ideas, suggestions are greatly appreciated. Thanks in advance.</p>