title: what is syntax for writing a private synonym in oracle 10G?
body: <p>I am using following syntax for creating a private synonym of a table in oracle 10G:</p>
  
  <pre><code>create private synonym &lt;synonym name&gt;
  for &lt;schema name&gt;.&lt;table name&gt;;
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <pre><code>ERROR at line 1:
  ORA-00905: missing keyword
  </code></pre>
  
  <p>Please guide me with correct syntax . I did research however i found syntax for public synonym only.</p>