title: Oracle view pulling data from schemas in different instances?
body: <p>How can you create an Oracle view that reads data from two schemas in two different instances?</p>
  
  <p>We know how to do this with two schemas in the same instance:</p>
  
  <pre><code>CREATE VIEW MYVIEW AS 
  SELECT X,Y,Z FROM A.MYTABLE
  UNION 
  SELECT X,Y,Z FROM B.MYTABLE
  </code></pre>
  
  <p>But what if schemas <code>A</code> and <code>B</code> are in different Oracle instances?</p>