mousaem

Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT rout

Discussion created by mousaem on Feb 4, 2012
Latest reply on Sep 10, 2012 by staspinar
Hi,

i have a feature class that is versioned with st_geometry storage. when i try to edit it using ArcMap with an Oracle user that has the full editing privileges i receive the following error:

Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00942: table or view does not exist
ORA-06512: at "SDE.SPX_UTIL", line 925
ORA-06512: at "SDE.SPX_UTIL", line 960
ORA-06512 at "SDE.ST_DOMAIN_METHODS", line 1906

however, when i try editing layer using the "schema owner", i don't receive this error !!! and editing works fine.

My Geodatabase environment is:

DBMS: Oracle 11g R2
ArcSDE Version: ArcSDE 10 SP2
Unix Server: IBM AIX 6.1

The layers are hosted in a "user-schema geodatbase".

Please check the attached error message.

can somebody help?

Thanks,

Attachments

Outcomes