If I user SQL Developer (version 17.4 and 18.2 both behave same) to connect to a DB and then execute:
desc table_name@link_name
I get:
SP2-0749: Cannot resolve circular path of synonym "cache_cs_users"
If I connect to same user on same DB with SQL*Plus Release 11.2.0.4 and execute the same command, I get a proper response with no error.
What could be the cause of this?
I also get an error in SQL Developer on that connection if I try to CREATE a procedure that uses the mentioned table over a DB link.
DB version is 11.2.0.3
Regards,
David