ORA-01775: Looping Chain Of Synonym on query user_sdo_geom_metadata
(Doc ID 2180792.1)
Last updated on APRIL 08, 2022
Applies to:
Oracle Spatial and Graph - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.0.2 version, Query Issues
When attempting to <INSERT INTO user_sdo_geom_metadata (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES ('AREA','POLYGONPOINTS',SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 0,1000000,1),SDO_DIM_ELEMENT('Y', 0,1000000,1)),NULL);>
the following error occurs.
ERROR
-----------------------
Error starting at line : 14 in command -
INSERT INTO user_sdo_geom_metadata (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID) VALUES ('AREA','POLYGONPOINTS',SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 0,1000000,1),SDO_DIM_ELEMENT('Y', 0,1000000,1)),NULL)
Error at Command Line : 14 Column : 13
Error report -
SQL Error: ORA-01775: looping chain of synonyms
01775. 00000 - "looping chain of synonyms"
*Cause:
*Action:
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |