Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a problem with the import of data (lines) to ArcSde Oracle.

2011-07-14 12:10:04| 22.9| 0.0|ERROR |Error while executing stream insert operation for table 'CHEMN'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(29875) SDE_ERROR_MSG1(ORA-29875: échec d'exécution de la routine ODCIINDEXINSERT ORA-20092: Maximum number of grids per feature (8000) exceeded. ORA-06512: à "SDE.ST_DOMAIN_METHODS", ligne 1982

Have you a solution ?


share|improve this question

1 Answer 1

You are not saying which ArcSDE version you are using but the Max no of grids value is controlled by the SERVER_CONFIG system table. You can use the sdeconfig command to alter these values. FOr an example with ArcSDE 9.2 have a look at http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=2344&pid=2337&topicname=Troubleshooting_the_ArcSDE_service

share|improve this answer
I use ArcSde 10 with Oracle 11g. –  user3120 Jul 14 '11 at 17:48
Hmm.. ok. Maybe your grid size defined is too small. Have a look at this esri thread : forums.arcgis.com/threads/… and also this paper on tuning grid sizes: proceedings.esri.com/library/userconf/proc05/papers/pap1858.pdf –  mapoholic Jul 15 '11 at 6:36
And how to change the grid size in ArcSde Oracle ? (SQL) –  user3120 Jul 15 '11 at 12:49
Using the sdelayer -o alter command, using the -g GRID, <gridsize> param. For more details check the online help: help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/… –  mapoholic Jul 15 '11 at 15:34

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.