AnsweredAssumed Answered

Problem trying to rebuild indexes and analyze tables using arcpy

Question asked by ufeliciano on Jul 15, 2014
Latest reply on Jul 15, 2014 by ufeliciano

ArcGIS 10.2

Oracle 11g

 

I want to use a python script to batch reconcile every day.  I'm following the steps found in the documentation "Using Python scripting to batch reconciles and post versions".  No problems reconciling, but I'm not able to rebuild indexes and analyze tables using the script.  If I set my connection for the data owner I received a privileges error message...

 

Traceback (most recent call last):

  File "E:\DAILY_TASKS\GDBRECONCILE\CDB_test.py", line 9, in <module>

    arcpy.RebuildIndexes_management(workspace, "SYSTEM", "GDB.Servhist", "ALL")

  File "C:\AG_Home\Desktop10.2\arcpy\arcpy\management.py", line 4723, in RebuildIndexes

    raise e

ExecuteError: ERROR 000684: Do not have administrative privileges.

Failed to execute (RebuildIndexes).

 

If I set the connection for the geodatabase owner, the script runs without any error messages, but looking from the database side the indexes are not recreated and the tables are not analyze.  Using the data owner connection in ArcCatalog there is no problem rebuilding the indexes using the Rebuild button in the properties window of the feature class as well as no issues analyzing the layer.  Is there any particular requirements to run this commands in the script???

 

Thanks in advance for any help...

Outcomes