WARNING, type: IN_WRONG_TABLESPACE and ERROR, type: MISSING_INDEX,

[Former Member]

Good morning,

I’d like you to help me with this situation, weekly I make a checkDB in the db13, when I check the Detail log I notice I have the following warnings:

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPR3.D021T_COPY, value: PSAPES46CD

BR0970W Database administration alert - level: WARNING, type: IN_WRONG_TABLESPACE, object: (table) SAPR3.D021T_DUPS, value: PSAPES46CD

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3.D021T_COPY

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3.D021T_DUPS

When I review if this tables exist, using the transactions SE11 and SE17, it says this tables doesn’t exist in an active way. I want to solve this problem because I want to configure RMAN to make a weekly backup.

Thanks a lot for your help.

[Former Member · Accepted solution]

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