Is This Content Helpful?
We're glad to know this article was helpful.
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 126.96.36.199, 188.8.131.52 and 184.108.40.206, but it does not occur in Oracle 9.0.1.x.
If using ArcSDE with Oracle versions 220.127.116.11 through 18.104.22.168 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 22.214.171.124 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,
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;