AnsweredAssumed Answered

ORA 01795- Maximum numbers of expressions error creating Local Geodatabase

Question asked by cyient.nam on Mar 17, 2016
Latest reply on Dec 1, 2017 by thaviti

we are creating local geodatabase using ArcGIS Runtime SDK .net and we are getting ORA-01795 Error. This error is not consistent when we restarted the server this is not reproducible.

 

 

Error: Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000::SELECT OBJECTID, GLOBALID, TEST_DATE, ASSESSMENT_TYPE, FUSERID, HF, POLE_ID, STATUS_CODE, SHAPE, CIP_SH.POLE.SE_ANNO_CAD_DATA FROM CIP_SH.POLE WHERE mdsys.sdo_filter(CIP_SH.POLE.SHAPE, MDSYS.SDO_GEOMETRY(:gtype1,:srid1,NULL,:elem_info1,:ordinates1), 'querytype=window') = 'TRUE' AND (OBJECTID NOT IN ( 409156 , 409184 , 409185 , 409225 , 409226 , 409247 , 409268 , 409276 , 409279 , 409281 , 409289 , 409290 , 409294 , 409300 , 409308 , 409316 , …..)

 

 

Attachments

Outcomes