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!

TOAD, options, plan_table

 

NB. This problem mostly occurs with an Oracle 10g database.

Joomla templates by a4joomla