rename index in 4.5B SAP environment

[Former Member]

HI,

We have customized program that is running on many our environments and it is using a HINT to choose best index for execution of the SQL statement. Since it is quite standard program, I do not want to change it.

The issue we have is that index that is mentioned in the hint has wrong name in one environment (LTAP~M instead of LTAP____M). It is very big index and I do not want to rebuild it if I do not have to. Is there a way in SAP to rename index (I know in oracle it can be done easily via ALTER INDEX RENAME command)

Regards,

Andrija

[fidel_vales · Accepted solution]

AFAIK, You cannot rename an index from inside SAP, you must use the mentioned oracle command. it takes less time than writting this answer, it does not rebuild the index, it is only a change on the oracle DD