SQL & PL/SQL

Hi All,

Am getting " Looping Chain of Synonyms issue. I have gone through the threads which are related to the same issue. But I didn't get the solution.Please find the below one and let me know how to fix this issue.

After referring related threads, I ran the below query.

{code}
SELECT OWNER, table_owner, table_name,SYNONYM_NAME
FROM dba_synonyms
WHERE owner = 'PUBLIC'
and table_owner='SCOTT';
{code}

{code}
OWNER TABLE_OWNER TABLE_NAME SYNONYM_NAME
PUBLIC SCOTT EMP_CODE EMP_CODE
PUBLIC SCOTT EMP_DETAILS EMP_DETAILS
PUBLIC SCOTT EMP_SEQ EMP_SEQ
PUBLIC SCOTT EMP_ID_SEQ EMP_ID_SEQ
PUBLIC SCOTT EMP_LIST EMP_LIST
PUBLIC SCOTT ADDITIONALINFO_SEQ ADDITIONALINFO_SEQ
...
...
..

{code}

Please suggest me how to resolve the issue.

Appreciate your help.

Thanks.