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

[#1]

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]

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