<p>I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging it, or do I just have to "create or replace" my way out of it?  </p>

<p>Is there a way to query the schema or whatever to find out what the current definition of a public synonym is?  </p>

<p>Even more awesome would be a graphical tool, but at this point, anything would be helpful.</p>

The data dictionary table
```
DBA_SYNONYMS
```
has information about all the synonyms in a database.  So you can run the query
```
```
SELECT table_owner, table_name, db_link
  FROM dba_synonyms 
 WHERE owner        = 'PUBLIC'
   AND synonym_name = <<synonym name>>
```
```
to see what the public synonym currently points at.