Skip to Content

Unknown type of tables created in DB level after SAP System Migration

Hello Experts,

Two days back I have performed a Sap heterogeneous system copy ( From AIX/Oracle to Linux Oracle).The migration went fine without any major issue.

However in DB02 I am seeing strange type of tables which are not in Dictionary level.

Example- DBSTATS#$ | DDACL#$ |DD09L#$

There are total 99 tables missing in DD level which exist in DB level.All of them are with #$.

Any idea what can be the issue?

I have also checked and all the tables (DBSTATS /DDACL/DD09L) exist in both DB abd DD level and contains valid data.

So these missing tables are duplicate of the actual tables which exist only in DB level and with no data/unique index.

Please suggest.

Best Regards,

Debaditya

db.png (19.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 16, 2017 at 02:49 AM

    Hi Debaditya,

    Would you please refer to SAP note 1753120 to do a clean up?

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2017 at 06:28 AM

    Hello James,

    Many thanks for your reply. I have followed the note and the tables are now cleaned up from the system.

    Best Regards,

    Debaditya

    Add comment
    10|10000 characters needed characters exceeded