You recently performed a migration/reorganization and the check db job is now showing some tablespaces reporting "IN_WRONG_TABLESPACE".
The BR0970W IN_WRONG_TABLESPACE error occurs when BRCONNECT finds an object which according to it's "category" (as defined in SE11 - table
name - technical settings) is in a wrong tablespace.
From the checkdb job you see the following types of errror in the BRCONNECT log.
- BR0970W Database aministration alert - level: WARNING, type:
IN_WRONG_TABLESPACE, object: (index) <index_name>, value: PSAPS<SID>
-BR0989W Unknown tablespace PSAP<SID> defined in table <"owner". "table_name" for table data class 'USER2'
In the first error (which is the most common one), the 'object' refers to either an "Index", "table" and sometimes "partition" along with the object name.
This helps you to indentify which object is having the issue
- Issue can Occur on any Database version
Data class, tabart, BR0989W , KBA , BC-DB-ORA-DBA , Database Administration with Oracle , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.