This is an old problem, there is even a TOAD related answer on StackOverflow :slight_smile: https://stackoverflow.com/a/247620 When the table TOAD_PLAN_TABLE is dropped, Explain Plan raises [Error] Explain Plan (3: 68): ORA-01775: looping chain of synonyms This cannot be resolved without dropp…

I saw this initially, but had my head down working on other stuff, then forgot to come back to it. I'll take a look.

ORA-01775: looping chain of synonyms with TOAD_PLAN_TABLE

JohnDorlon December 9, 2019, 9:59pm 4

Update 12/9/2019: Fixed in Toad for Oracle 13.3 Beta

Topic		Replies	Views
Toad plan table issue Toad for Oracle & DevOps Toolkit	4	1830	April 29, 2020
Explain Plan ORA-00942: table or view does not exist Toad for Oracle & DevOps Toolkit	3	4782	February 4, 2022
Plan table Toad for Oracle & DevOps Toolkit	14	4802	April 7, 2011
Am receiving message "'TOAD.TOAD_PLAN_TABLE' is old version" - how to upgrade Oracle instance? Toad for Oracle & DevOps Toolkit	2	2068	January 20, 2015
get EXPLAIN PLAN error in both Toad 9.7 and 10.1 Toad for Oracle & DevOps Toolkit	1	738	March 31, 2010