ORA-13282: failure on initialization of coordinate transformation (Doc ID 2930779.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Spatial query using sdo_transform and failing with ORA 13282

SELECT ...
FROM ...
WHERE (SDO_RELATE(<geometry column>, sdo_cs.transform(<geometry> ...
returns

ERROR at line 3:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-13282: failure on initialization of coordinate transformation

i.e simple transformation

SQL> select sdo_cs.transform(sdo_geometry(2001, 40983, sdo_point_type(6561666.6667, 1640416.6667, null), null, null), 2000006) from dual;
select sdo_cs.transform(sdo_geometry(2001, 40983, sdo_point_type(6561666.6667, 1640416.6667, null), null, null), 2000006) from dual
  *
ERROR at line 1:
ORA-13282: failure on initialization of coordinate transformation
ORA-06512: at "MDSYS.SDO_CS", line 124
ORA-06512: at "MDSYS.SDO_CS", line 174
ORA-06512: at "MDSYS.SDO_CS", line 6520
ORA-06512: at "MDSYS.SDO_CS", line 3488

 
ERROR
-----------------------
ORA-13282

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.