1.1.11

SAP Note 16613 - SAPDBA: Warning due to incorrectly placed indexes

Symptom:

SAPDBA issues the message:
"There are some tables in tablespace PSAPnameD, which have indexes in other tablespaces than PSAPnameD or PSAPnameI ..."

Cause and prerequisites

Incorrect assignment of indexes to the tablespaces in the SAP System.

Solution
You can continue working despite the message, as errors occur only rarely in such cases during restoration of the incorrectly placed indices.
The incorrectly placed indexes are restored in the old tablespace using the old storage parameters (e.g. no "compress").
To make sure, you can check the scripts before starting to see whether some reserve space is still available in the tablespaces listed in the warning message, or manually change the tablespace name by editing the scripts before you start (note, however, that SAPDBA will not perform any space checks).
In the rare cases where errors actually occur when restoring the indexes, you can either let the reorganization continue, or interrupt it, expand the affected tablespace, and then continue with the restart option.

No comments:

Post a Comment