SAP Knowledge Base Article - Preview

1578001 - BR0970W IN_WRONG_TABLESPACE, BR0989W Unknown tablespace ,

Symptom

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


Read more...

Environment

- Oracle
- Issue can Occur on any Database version

Keywords

Data class, tabart, BR0989W , KBA , BC-DB-ORA-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.