Error: ORA-13364: Layer Dimensionality does not match geometry dimensions

Error Message

When performing a spatial query on feature classes that are stored with Oracle Spatial, the following error message may occur:

"ORA-13364: Layer Dimensionality does not match geometry dimensions
ORA-06512: at "MDSYS.SDO_TUNE", line 1355"


ArcSDE uses the Oracle Spatial function SDO_TUNE.EXTENT_OF with 3-D or 4-D data. The error occurs with Oracle, and, but it does not occur in Oracle 9.0.1.x.

Solution or Workaround

If using ArcSDE with Oracle versions through and intending to use Oracle Spatial (SDO_GEOMETRY) to store the spatial data, the Oracle Patch 2892787 is needed. The patch addresses a problem with SDO_TUNE.EXTENT_OF, which is a function that ArcSDE uses. According to Oracle, this patch is included in the patch set.

The patch can be obtained from an Oracle Representative or through your Oracle MetaLink account on the Oracle Web site. Please read the 'readme' file that accompanies the patch installation instructions.

Please be aware that ESRI cannot be responsible for problems that may occur during the implementation of a non-ESRI product, as is the Oracle patch.

Use the code below to test if the problem is present on your server. If the problem exists on your server, the error message will display. If the problem does not exist on your server, there will be an answer to your query.

create table TEST_MZ_LINE
(objectid number(38) PRIMARY KEY,
pipename varchar2(32),
feature_id number);

insert into TEST_MZ_LINE values
MDSYS.SDO_ORDINATE_ARRAY (612721.29, 5900624.25, 0,0,
612723.021, 5900624.08, 1.73913312, 1.73913312,
612721.922, 5900611.3, 14.5608837, 14.5608837,
612696.423, 5900613.37, 40.1434824, 40.1434824,
612693.631, 5900577.71, 75.9138061, 75.9138061,
612692.01, 5900576.14, 78.1697353, 78.1697353,
612690.558, 5900574.68, 80.227168, 80.227168,
612689.696, 5900573.36, 81.80788, 81.80788,
612689.046, 5900571.5, 83.7812428, 83.7812428)),


insert into USER_SDO_GEOM_METADATA values
MDSYS.SDO_DIM_ELEMENT('X', 612660, 612740, .0005),
MDSYS.SDO_DIM_ELEMENT('Y',5900560, 5900650, .0005),
MDSYS.SDO_DIM_ELEMENT('Z', 0, 100, .0005),
MDSYS.SDO_DIM_ELEMENT('M', 0, 100, .0005))


create index LINEMZ_RTSDX on TEST_MZ_LINE(SHAPE) indextype is
mdsys.spatial_index PARAMETERS ('SDO_INDX_DIMS=2');

select sdo_tune.extent_of('TEST_MZ_LINE','SHAPE') from dual;

Related Information