Ora-29876 while trying to compress geodatabase in Oracle

VedranDevcic

Hi,

We are unable to compress geodatabase with ArcCatalog 9.2. Our infrastructure is:

 

• Geodatabase stored with ArcSDE 9.3.1 in Oracle 11g
• ArcCatalog 9.2 client

 

We get the following error (screenshot attached):

 

ORA-29876: failed in the execution of the ODCINDEXDELETE routine

ORA-00933: SQL command not properly ended

ORA-06512: at SYS.DBMS_SQL line 1053

...

at SDE.ST_DOMAIN_METHODS, line 1969

Any help appreciated.

error.png

JenniferAcunto_1-1720703201786.png

KevinDunlop

In current release of ArcGIS desktop, connecting and performing actions in a lower client to a higher GDB isn't normally a problem.  However, in earlier release it was.  So I would first try upgrading your client to at least 9.3.1 to match your database, or even to version 10.X.  Also remember that 9.3.1 does not support the most current version Oracle 11g and requires special patches.  So you will need to make sure that your SDE is compatible with the database version you are using.

If you can't upgrade, then the question is, has the compress worked in the past?  If so, what has changed since the worked last?  This would be the mostly problem area.

Finally, read this post.  It might be a bad index. Underlying DBMS error [ORA-29875: failed in the execution of the ODCIINDEXINSERT rout