Skip to main content

ORA-01775 Looping chain of synonyms

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


  

Looping-chain-of-synonyms

















It's a toad issue.
1. In Toad go to View>Toad Options>Oracle>General 
Looping-chain-of-synonyms



looping-chain-synonyms
remove TOAD_PLAN_TABLE 
from EXPLAIN PLAN section and put PLAN_TABLE (i.e. synonym for SYS.PLAN_TABLE).










looping-chain-synonyms


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









looping-chain-of-synonyms

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
Labels:

Comments

Post a Comment

Popular posts from this blog

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS
Post a Comment
Read more

No free space to rebalance ASM disk group

   To day we found below warning message from Exadata system: Warning: Software Alert 92_1 Event Time 2025-01-23T16:19:57+06:00 Description Insufficient free space to rebalance the ASM disk group: RECOC1 Affected Server Name ******* Server Model Oracle Corporation ORACLE SERVER X9-2 Chassis Serial Number 2217XCD00X Release Version 24.1.5.0.0.241016 RPM Version 24.1.5.0.0.241016 Recommended Action Please refer to MOS Doc 1551288.1                                                                                                I am search  Chatgpt and found below solutions. Rebalancing an ASM (Automatic Storage Management) disk group in Oracle is a process where the disk group redistributes data...
Post a Comment
Read more

Error Initializing Opera: module 15

Solutions: You should manually remove directories name as "Opera" from  %PROGRAMFILES% ,%APPDATA% and %USERPROFILE% . RUN(Windows Logo Key + R)-> Enter '%PROGRAMFILES%' -> Then press OK Button. Open a new window, There find Opera folder and delete it. Same as %APPDATA%  and %USERPROFILE%. What programming languages should I learn to make a website How do i transfer music from my mac to my iPhone using the iTunes HOW TO FIX ICE CREAM SANDWICH UPDATE ERRORS !!! Fix an app that isn't working properly in Nexus how to reset Google nexus 7 Screen flicker problem in iPhone 5 DATE AND TIME PROBLEM IN IPHONE5 Another way: IF it's install in C drive you can delete opera folder from below location : c: \ Program Files \ Opera \ c: \ Documents and Settings \ Username \ Application Data \ Opera \ c: \ Documents and Settings \ Username \ Local Settings \ Application Data \ Opera \ Any you getting any problem give a comments. You can also see...
Post a Comment
Read more