SAP Knowledge Base Article - Preview

2198923 - Tables of type <table_name>~~OLD are left in the database after the system switch upgrade


After the system switch upgrade using Software Update Manager (SUM), tables with suffix ~~OLD are left in the database. Due to this, following symptoms can be seen:

  • Old tablespace cannot be deleted as it contains such objects
  • Objects of type ~~OLD can be seen in DB02 transaction under "Missing tables/indexes" > "Unknown objects in ABAP Dictionary"
  • DBcheck might return  IN_WRONG_TABLESPACE warnings for tables of type <table_name>~~OLD
  • ERROR in DBCLONE Phase: 1EETGCLN cannot use duplicate index name <Index name> because of existing objects with suffix ~~OLD
  • MAIN_SHDIMP/EU_CHECK informs you about the existence of <table_name>~~OLD



Upgrade using Software Update Manager (SUM) tool


SAP NetWeaver all versions


IN_WRONG_TABLESPACE, BR0970W, Database administration alert - level: WARNING, rename, CHECKDB, DB13, ~~, OLD, shadow table, MAIN_POSTCLEAN/DBCLEAN_UPG, DROP TABLE, TABLE~~OLD, TABNAME~~OLD, SAPup, MAIN_SHDIMP/EU_CHECK, EU_IMPORT1 , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem

About this page

This 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.