title: Refer tables in another schema in oracle
body: <p>I would like to refer to multiple tables in another schema without schema prefix or altering the session.</p>
  
  <p>I have the below query -</p>
  
  <pre><code>Select * from schema1.app_table 
  </code></pre>
  
  <p>There are multiple queries like these in packages which have schema prefix. </p>
  
  <p>I have to export the tables to a different schema. I really don’t want to change the schema prefix in all the packages. </p>
  
  <p>I tried synonyms and unfortunately it didn't work.</p>