SAP Note 10426 - Reorganization: indices in wrong tablespace.

Symptom

During the reorganization of tablespace PSAPBTABD/PSAPSTABD, the indices are not in the corresponding index tablespace, as stated in the documentation.

Cause and prerequisites

Delivery error in R/3 Releases <> Solution
The situation described above does not represent a problem, as the indices are not lost because of the inconsistency. If a customer wants to move the indices anyway, they should proceed as follows:
1. Edit script indSTABI.sql
2. Change the tablespace information in the CREATE INDEX statements
TABLESPACE PSAPSTABI --> TABLESPACE PSAPBTABI
3. Stop the R/3 System
4. Delete the affected indices:
sqlplus system/manager
SQL> drop index sapr3.;
5. Redefine the indices:
SQL> start indSTABI.sql

Keyword: sapdba