AnsweredAssumed Answered

Underlying DBMS error[ORA-29902: error in executing ODCIIndexStart() routine

Question asked by mousaem on May 5, 2014
Latest reply on Jun 9, 2014 by mousaem
Hi,

My Current Environment:
Oracle Database 11gR2 (11.2.0.3)
ArcSDE 10.2
Server: IBM AIX 6.1

I have a geodatabase schema where it used to be stored in ???SDEBINARY???, I have converted it to ???st_geometry??? successfully with no problems.

I can view the data using the ???oracle schema owner user??? with no issues in ArcCatalog. However, when I try to view the data using another Oracle user (application user) using ArcCatalog who has full read/edit permissions on these layers I face the following error:

Underlying DBMS error[ORA-29902: error in executing ODCIIndexStart() routine
ORA-01031: insufficient privileges
ORA-06512: at "SDE.SPX_UTIL",line 847
ORA-06512: at "SDE.SPX_UTIL",line 891
ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 105

please refer also to the attached snapshot image of the error ( i have wiped the layer name for security reason).


did somebody face this error before ?

Thanks in advance.

Outcomes