Hi ,

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?

Thanks
Sridhar