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
Perfect ...Thanks a lot :)
ReplyDeleteFixed my issue, thanks!
ReplyDelete