Index management in TREX
We have a webshop running and are using TREX for the product catalog. The catalog is replicated from ECC using program ISA_CATALOG_REPLICATION.
Something seems to have gone wrong since there are a lot of indexes on TREX where there should only be a few. I'd like to cleanup the indixes on TREX. This can be done from the administration tool, but then ECC will not be notified and ECC will expect indexes on TREX that are no longer there. This will result in unsuccessfull replications as the cleanup will not work. If I do the cleanup from ECC using SRMO, I'd have to delete about 1900 indices manually. This would take about two years of my time
The big question: is there a way to cleanup these indexes, and keep ECC and TREX in sync? A mass maintenance tool of some sort maybe?
kind regards, Wilbert