If you get a message “IN_WRONG_TABLESPACE” in your CHECKDB log especially after a SAP upgrade project then you should check the following steps…

DB13 CHECKDB process completed with “Warning” and looks like below ;

Also log has following warnings ;

Lets check the related tablespace for TABLES from SQLPlus ;

SQL> select table_name from dba_tables where tablespace_name=’PSAP<SID>640′;

Lets check the related tablespace for INDEXES from SQLPlus ;

SQL> select index_name from dba_indexes where tablespace_name=’PSAP<SID>640′;

Start moving TABLES to other TABLESPACE

SQL> alter table TRBAT move tablespace psap<SID>;

Start moving INDEXES to other TABLESPACE

SQL> alter index “MSSSTORAGE~0″ rebuild tablespace PSAP<SID>;

Lets check the TABLES from old PSAP<SID>640 tablespace

Lets check the INDEXES from old PSAP<SID>640 tablespace

Start the CHECKDB from DB13 and check the log again