topic Re: rebuild indexes in Geoprocessing Questions

rebuild indexes

SyedMasood_Khadri — Mon, 14 Jul 2014 11:32:05 GMT

I have oracle tables with sdo_geometry data type for shape columns and registered with geodatabase.

I am not able to rebuild indexes from ArcGIS catalog or by using Geoprocessing tools.

When i see feature class properties, rebuild indexes button is not available.

Re: rebuild indexes

ChristianWells — Mon, 14 Jul 2014 14:35:04 GMT

Can you provide some more information regarding this issue:

What is the error (if any) you receive when running the GP tool?
Do any locks exist on the data?
Are you currently logged in as the data owner?
Have you tried rebuilding the indexes from Oracle?

CREATE INDEX cola_spatial_idx
ON cola_markets(shape)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

Re: rebuild indexes

Ulises — Mon, 14 Jul 2014 22:40:24 GMT

I have a similar issue...

Mine is an Oracle database with several datasets and a stand-alone feature class. In ArcCatalog, connecting with the data owner, I see the Rebuild button in the indexes tab for the feature classes in the datasets. The fc is not versioned and in ST_Geometry type. No problem here, I can see the index date updated in the Oracle tables.

The stand-alone fc is not versioned and was stored using ESRI LOB type; in this case the Rebuild button is not shown in the Indexes tab in the properties window. Wondering why...???

Also, I ended using the Rebuild button in AC because I tried to use the python window to run the arcpy.rebuildindexes_management command but I kept getting errors about not having administrative privileges?!?! Did not find any restrictions in the documentation about using the command window so I'm not sure why I can rebuild using AC but not using the command.

Re: rebuild indexes

SyedMasood_Khadri — Tue, 15 Jul 2014 07:18:17 GMT

I have connected as data owner from Arc catalog. GP tool is not responding for long time without any error. Also there is no rebuild button in feature class properties. This happens to the tables with SDO_GEOMETRY, created by using Oracle SQL and registered with SDE geodatabase. But I am able to build indexes for these tables from Oracle SQL.

I am able to rebuild indexes from Arc Catalog and GP tool if the feature classes are created by using Arc Catalog.

Re: rebuild indexes

Ulises — Tue, 15 Jul 2014 12:45:59 GMT

In my case the feature class that do not show the button was created using python scripts and sde commands to generate a spatial view initially and afterwards exported to the mentioned fc. Can someone confirm if this is the expected behaviour?

Re: rebuild indexes

DonOpgenorth — Tue, 12 Aug 2014 20:08:07 GMT

I've moved your post into the Geoprocessing space. You will get a much better answer here as the GeoNet Help is intended for community help and feedback. I have also added in a few additional tags. You can see more on the community structure, and what topics are under each space from the following documents:

GeoNet Community Structure

ArcGIS Discussion Forums Migration Strategy

Thanks!

Don