BRCONNECT please activate the monitoring attribute for table SAPKCW./BI0/F0

[Former Member]

HI.

after updating statistic (in db13) i have messages like that:

BR0988W Bitmap index /BI0/F0ABC_C02~060 selected for checking statistics - please activate the monitoring attribute for table SAPKCW./BI0/F0ABC_C02

I used note Note 442395 - Descriptions of specific BR messages.

but when i do:

SQL> alter table "SAPKCW./BI0/F0ABC_C02" monitoring;

alter table "SAPKCW./BI0/F0ABC_C02" monitoring

*

ERROR at line 1:

ORA-00942: table or view does not exist.

[former_member204746 · Accepted solution]

use this command:

alter table SAPKCW."/BI0/F0ABC_C02" monitoring;

you must put quotes around the table name, and not include the schema.