0

I am using an Oracle 11g database . The code below doesnt allow me to drop indexes on a table.

import arcpy


# Remove indexes and statistics for gis feature class delta tables
COND=r'E:/GISScheduledTasks/DMZGeodatabaseMaintenance/sde/arcfm_synctest.sde/ARCFM.CONDUCTORINFO'
arcpy.RemoveIndex_management(COND,"G190PRIOHCONDUCT;G190PRIOHELECTRI;G190PRIUGCONDUCT;G190PRIUGELECTRI")
print('complete')

It gives the attached error.Could someone advise on python coding for dropping indexes on a table within an enterprise database? enter image description here

  • 1
    Use List for index name instead of string. ["G190PRIOHCONDUCT","G190PRIOHELECTRI","G190PRIUGCONDUCT","G190PRIUGELECTRI"] – BBG_GIS Nov 2 '17 at 22:13
  • Please always provide errors as text rather than pictures. – PolyGeo Nov 3 '17 at 0:37
  • the List isnt working for me , it gives me an erorr which says " Invalid value for index name or index item" – Shaniceb Nov 6 '17 at 12:47
  • How were the indexes created? In Oracle or in ArcGIS? – GISGe Nov 6 '17 at 13:47
  • Hi, they were created in ArcGIS. but I need to create a script that can first drop them , then ill create a the script that would re-add them . – Shaniceb Nov 6 '17 at 13:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.