import arcpy, cx_Oracle from arcpy import env env.workspace = r"C:\TEMP\Python\Test.gdb" env.overwriteOutput = 1 fc = "Hospitals" list = [] # append all CODE values from feature class to list rows = arcpy.SearchCursor(fc) for row in rows: list.append(row.getValue("FAC_TYPE")) # create a connection to Oracle instance connstr='vector/vector@orcl' conn = cx_Oracle.connect(connstr) curs = conn.cursor() oracleList = [] # query Oracle table using items from list and append to new list for item in list: curs.execute('select FAC_TYPE FROM Hospital_Info where FAC_TYPE = ' + str(item)) for row in curs: oracleList.append(row[0]) # Find items that have duplicates and delete from feature class for item in set(oracleList): if oracleList.count(item) > 1: arcpy.MakeFeatureLayer_management(fc, "Hospital_Lyr", "FAC_TYPE = " + str(item)) arcpy.DeleteRows_management("Hospital_Lyr") print "Successfully deleted rows" conn.close()
Hi Jin,
This is actually for ArcGIS 10. You will need to replace 'arcpy' with 'gp' to have this work with 9.3. Also, you will need to make a few changes to the 'SearchCursor'. Here is a link that discusses how to do this for 9.3.