title: How to correctly make a public synonym
body: <p>This is a pretty silly one, but I need help.</p>
  
  <p>I have a table owned by mydbowner.  It is named mydbowner.mytable.  I tried to make a public synonym by issuing the command:</p>
  
  <p>CREATE OR REPLACE PUBLIC SYNONYM mytable FOR mydbowner.mytable;</p>
  
  <p>When I do this, and I query the table I get:</p>
  
  <p>ORA-01775: looping chain of synonyms</p>
  
  <p>How do I make this synonym without having the problem.</p>