IN_WRONG_TABLESPACE After SAP Version Upgrade

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 ;

IN_WRONG_TABLESPACE After SAP Version Upgrade

Also log has following warnings ;

IN_WRONG_TABLESPACE After SAP Version Upgrade

Lets check the related tablespace for TABLES from SQLPlus ;

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

Lets check the related tablespace for INDEXES from SQLPlus ;

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

Start moving TABLES to other TABLESPACE

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

Start moving INDEXES to other TABLESPACE

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

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

IN_WRONG_TABLESPACE After SAP Version Upgrade

Start the CHECKDB from DB13 and check the log again

IN_WRONG_TABLESPACE After SAP Version Upgrade

 

 

 

 

 

 

 

 

 

Leave a Reply


3 + = seven

Blogroll