Hi Yolanda,
D021T_COPY and D021T_DUPS are not standard tables, created by SAP installation. If they are not used by an application or copied by the backup reason, you can drop the objects safely.
Best regards,
Orkun Gedik
Hello Yolanda,
This error is common and a note in SAP exists. To remove them from the checkdb you can simply add
them to the DBDIFF table as per note #33814 ->
under section.
Entering/Maintaining exceptions in DBDIFF
One thing to consider is
"Objects which are missing on the database but which have been created
in the ABAP/4 Dictionary must not be entered as an exception in the table but
instead be created on the database", however I see you mentioned above they are not existing your system and are not active.
Best Regards
Rachel
Thank you and for answering,
I was reviewing the database directly using Oracle SQL developer and I see the two tables exist.
Hello Yolanda,
If both tables exist also in the abap then you need to move them to the correct tablespace via the BRSPACE tool. From Brtools 7.00 there is an option "-l" for example "-l PSAPES46CD". The new tablespace will then take over all data classes from the old tablespace and no manipulation
of the tables DD09L, DDART, DARTT, TAORA, ISORA and TSORA would be necessary. Brtools are database dependent so you can use a higher version with lower oracle versions. Please refer to oss note #12741 to see if Brtools 7.00 is suported with your Oracle version. Unfortunately I cannot find the above tables internally, so I cannot advise you to drop them but if they already exist I would recommend to move them to the correct tablespace and create the indexes if they already are present in the ddic and database to avoid the warnings in the checkdb job. To reorganise the tables with BRSPACE the option -l is listed in oss note #646681. Indexes can be created for the tables via SE14 transaction. As with all changes please ensure you take a backup afterwards,
Best Regards
Rachel
These tables have been created on the database level as a backup of table D021T it seems for some reason previously . Since these are non-standard SAP tables , you can delete them from the database level as suggested by Orkun. Do not add these tables in the exception table DBDIFF as this contains SAP provided internal tables which are not part of the ABAP dictionary and SAP tools such as R3ldctl are aware of this table set in DBDIFF.
To be absolutely sure check with SAP via an OSS message if the tables are standard.
Also just to be extra cautious , check if the entries for these tables exist in NAMETAB tables DDNTT and DDNTF which ideally should not when you delete the tables.
Regards
Ratnajit
Hi Yolande
I checked an internal test system based on the other replies above, you should see the original table D021T in SE11/SE14. It is a standard table and it looks like you have a copy of the table leftover from some other operation. Proceed as per the other suggestions.
Best Regards
Rachel
