Download it here
The original version sent by none others than the actual Garry!
Pages
▼
[TOAD] Oracle explain plan error looping chain of synonyms - fix
TOAD is a powerful client for Oracle DB, although I have to admit SQLDeveloper is not that bad either (and it's also free).
Sometimes while trying to get an explain plan, the error "ORA-01775 - looping chain of synonyms" might occur.
The fix is quite easy: from the options menu go to the Oracle - General section and find the Table field. The value there should be PLAN_TABLE rather than TOAD_PLAN_TABLE.
Save settings, restart TOAD and you're set
Sometimes while trying to get an explain plan, the error "ORA-01775 - looping chain of synonyms" might occur.
The fix is quite easy: from the options menu go to the Oracle - General section and find the Table field. The value there should be PLAN_TABLE rather than TOAD_PLAN_TABLE.
Save settings, restart TOAD and you're set