title: Oracle: is it possible to create a synonym for a schema?
body: <h3>Firstly</h3>
  <p>I am an oracle newbie, and I don't have a local oracle guru to help me.</p>
  <h3>Here is my problem / question</h3>
  <p>I have some SQL scripts which have to be released to a number of Oracle instances.
  The scripts create stored procedures.<br />
  The schema in which the stored procedures are created is different from the schema which contains the tables from which the stored procedures are reading.</p>
  <p>On the different instances, the schema containing the tables has different names.</p>
  <p>Obviously, I do not want to have to edit the scripts to make them bespoke for different instances.</p>
  <p>It has been suggested to me that the solution may be to set up synonyms.</p>
  <p>Is it possible to define a synonym for the table schema on each instance, and use the synonym in my scripts?</p>
  <p>Are there any other ways to make this work without editing the scripts every time?</p>
  <p>Thank you for any help.</p>