Hi all,
I am working on 8i, Linux.
A developer recreated synonyms for tables in "user_tables"
after doing he " select sysdate from dual; "
gives ORA-01775: looping chain of synonyms
also in alert log
ORA-00604: error occurred at recursive SQL level 1
ORA-01775: looping chain of synonyms
ORA-12012: error on auto execute of job 1
ORA-01775: looping chain of synonyms
I told him to check if there is duplicate in synonyms,drop synonyms & recreate again.(after taking DDL of all synonyms)
he was unable to drop any synonym as it gave same error ora 01775.
tried to login via Enterprise manager also, gave him ora 01775.
trail and error he created synonym for "dual".(as he was not able to get sysdate, he thought its a problem in "dual")
and after creating synonym for dual
"create or replace public synonym dual for sys.dual;"
things were back to normal ie users were able to connect to application.
can anybody please explain is it correct what he has done?
if any more details required please let me know.