The Rebuild Indexes tool seems to fail if a feature class or table has more than 8 attribute indexes (includes OBJECTID and GLOBALID) and the "ALL" option is used. "ONLY_DELTAS" works fine.
Does anyone know why there would be an 8 index limit?
ArcGIS 10.2.1, Oracle 11g.
fail? what is the error?
all tables? or just one?
always at 8 if all tables?
I don't suppose you can test the same files on a more recent version of arcmap
The error is the generic "DBMS Error", which doesn't tell us much about what might be going on. All the tables/feature classes that have more than 8 will fail - there are about 6 of them. All of those that have less work fine.
I am running this with ArcGIS 10.5 now and it does appear to be working fine. It gives a more detailed error message ("Specified Index does not exist") for 2 tables, so it does appear that there are some issues at the Database level.
Due to some feature class extensions, I would prefer to have this run at 10.2.1, but at least it looks like using 10.5 will be a reasonable workaround for now.
Thank you for your help
no problem, at least you have narrowed the issue to the version specific level. I can't find anything useful on that generic error.