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. –  twisig 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) –  twisig 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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.