- Written by Erwin
- Category: Oracle
- Hits: 4574
When you're trying to do an explain plan (CTRL + E) in TOAD (for Oracle) and you get the error "ora-01775 - looping chain of synonyms" than here is a solution.
Open TOAD and open the Options window (via View => Options). Go to Oracle - General and check if Table reads 'TOAD_PLAN_TABLE', change it to 'PLAN_TABLE'.
Close the Options window with Ok and restart TOAD. That's it!
NB. This problem mostly occurs with an Oracle 10g database.