ORA-01775: Looping Chain Of Synonym on query user_sdo_geom_metadata (Doc ID 2180792.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information 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:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms