I am facing with the problem
SQL> desc dd_ec_le1_dates;
SP2-0749: Cannot resolve circular path of synonym "dd_ec_le1_dates"
If i use this statement
select count(*) from table_name
then i get the following error
ERROR at line 1:
ORA-00942: table or view does not exist
I am accessing this table from different schema.
for this problem i have dropped the public synonym for this table recreated it still the problem persists..
what is the problem i am unable to access the table even though i have created a public synonym?