ERROR
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 9.2.0.1, 9.2.0.2 and 9.2.0.3, but it does not occur in Oracle 9.0.1.x.
Warning:
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.
Code:
create table TEST_MZ_LINE
(objectid number(38) PRIMARY KEY,
shape MDSYS.SDO_GEOMETRY,
pipename varchar2(32),
feature_id number);
insert into TEST_MZ_LINE values
(1,
MDSYS.SDO_GEOMETRY(4002,NULL,NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),
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)),
'LRS_PIPE_01',1);
commit;
insert into USER_SDO_GEOM_METADATA values
('TEST_MZ_LINE',
'SHAPE',
MDSYS.SDO_DIM_ARRAY(
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))
,null);
commit;
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;
Article ID:000006547
Get help from ArcGIS experts
Download the Esri Support App