Thanks for the question, santhoshreddy.
Asked: November 23, 2016 - 3:12 pm UTC
Last updated: November 26, 2016 - 3:21 am UTC
Version: 11g
Viewed 1000+ times
SQL> SQL> conn / as sysdba Connected. SQL> create view tmp_view as select * from sys.tab$; View created. SQL> grant select on tmp_view to SELECT_CATALOG_ROLE; Grant succeeded. SQL> create public synonym tmp_view for tmp_view; Synonym created. SQL> conn mcdonac/blah Connected. SQL> select count(*) from tmp_view; COUNT(*) ---------- 3167 1 row selected. SQL> conn / as sysdba Connected. SQL> drop view tmp_view; View dropped. SQL> conn mcdonac/blah Connected. SQL> select count(*) from tmp_view; select count(*) from tmp_view * ERROR at line 1: ORA-01775: looping chain of synonyms SQL> conn / as sysdba Connected. SQL> drop public synonym tmp_view; Synonym dropped. SQL> create view tmp_view as select * from sys.tab$; View created. SQL> grant select on tmp_view to SELECT_CATALOG_ROLE; Grant succeeded. SQL> create synonym mcdonac.tmp_view for tmp_view; Synonym created. SQL> conn mcdonac/blah Connected. SQL> select count(*) from tmp_view; COUNT(*) ---------- 3167 1 row selected. SQL> SQL> conn / as sysdba Connected. SQL> drop view tmp_view; View dropped. SQL> SQL> conn mcdonac/blah Connected. SQL> select count(*) from tmp_view; select count(*) from tmp_view * ERROR at line 1: ORA-00980: synonym translation is no longer valid SQL> SQL>
santhoshreddy podduturi, November 25, 2016 - 2:10 am UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!