Error when running Explain Plan: "Error: 'ORA-01775: looping chain of synonyms'" (4348698)

User receives this error when executing the Explain Plan for a SQL statement:

"Error: 'ORA-01775: looping chain of synonyms'"

Make sure that Toad is referencing a valid Explain Plan Table. Please follow these steps to verify:

1) Go to View | Options | Oracle | General
2) On the right, make sure that the 'Explain Plan' section has a valid Explain Plan table. Please change the values if Toad is not referencing a valid Explain Plan table.

You can use this script to create an Explain Plan Table:

CREATE TABLE TOAD_PLAN_TABLE
(
STATEMENT_ID VARCHAR2(32 BYTE),
TIMESTAMP DATE,
REMARKS VARCHAR2(80 BYTE),
OPERATION VARCHAR2(30 BYTE),
OPTIONS VARCHAR2(30 BYTE),
OBJECT_NODE VARCHAR2(128 BYTE),
OBJECT_OWNER VARCHAR2(30 BYTE),
OBJECT_NAME VARCHAR2(30 BYTE),
OBJECT_INSTANCE NUMBER,
OBJECT_TYPE VARCHAR2(30 BYTE),
SEARCH_COLUMNS NUMBER,
ID NUMBER,
COST NUMBER,
PARENT_ID NUMBER,
POSITION NUMBER,
CARDINALITY NUMBER,
OPTIMIZER VARCHAR2(255 BYTE),
BYTES NUMBER,
OTHER_TAG VARCHAR2(255 BYTE),
PARTITION_ID NUMBER,
PARTITION_START VARCHAR2(255 BYTE),
PARTITION_STOP VARCHAR2(255 BYTE),
DISTRIBUTION VARCHAR2(30 BYTE),
OTHER LONG
)