[GIS] ArcSde Oracle Maximum number of grids per feature (8000)

enterprise-geodatabaseoracle-dbms

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 ?

Thanks

Best Answer

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