ORA-01775: looping chain of synonyms / SP2-0749: Cannot resolve circular path of synonym

The following operations may result in these errors.

SQL> create table fruit (Name varchar2(10), Price float);

SQL> create public synonym fruit for fruit;

SQL> drop table fruit;

SQL> create table fruit (Name varchar2(10), Price float);

SQL> select count(*) from fruit;

ORA-01775: looping chain of synonyms

SQL> desc fruit

SP2-0749: Cannot resolve circular path of synonym "fuit"

To fix this problem:

SQL> drop public synonym fruit;

-----------------------------------------------------------------------------------------------------------------

Watch the blessing and loving online channel: SupremeMasterTV live

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.