ORA-01775 Looping chain of synonyms

Explain Plan Error: ORA-01775: Looping chain of synonyms

  

It's a toad issue.

1. In Toad go to View>Toad Options>Oracle>General 

remove TOAD_PLAN_TABLE 

from EXPLAIN PLAN section and put PLAN_TABLE (i.e. synonym for SYS.PLAN_TABLE).

Generally after an upgrade to new version of toad, this gets overwritten and you start getting this error.

Cheers !!!! . 

[If you find helpful  please share it.]

Alternative solution from Dell support

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
)

-- cheers