on 02-22-2008 10:37 AM
Hi,
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03BF0SETUP
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03BX0SETUP
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03UM0SETUP
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03BF0SETUP~0
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03BX0SETUP~0
BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03UM0SETUP~0
even after i created stats for these tables, in next checkdb run stat's are missing....
can anybody give me solution pls?
Thanks in adv.
Hello,
I normally run the RSANAORA report.
Assuming you have ORACLE database, what you can do is start the report in SE38 transaction.
Provide the list of objects tables/index and use the compute function in the selection screens to compute statistics for the same.
You can run the report in background.
Note that you can also rebuild indexes online using this report.
Also, you may wish to rebuild indexes using DB02 , it internally runs the same report.
I wrote a blog on [Rebuilding indexes online using DB02|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8734] [original link is broken] [original link is broken] [original link is broken];
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
SAP always advices to carry out such activitithe BRTOOLS.
Run BRTOOLS--
Here Provide the TblSpace name or the Table Name or the Index name as the case may be.
In yr case the tble names are
MC03BF0SETUP
MC03BX0SETUP and table index are
MC03BF0SETUP~0
SAPR3.MC03BX0SETUP~0
SAPR3.MC03UM0SETUP~0
input these parameters and continue as per the guided procedure.
Hope this helps.
Pl award suitably if resolved.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
>> can anybody give me solution pls?
Please check, if the objects are recreated.
> shell> sqlplus "/ as sysdba"
> SQL> select OBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, CREATED, LAST_DDL_TIME from ALL_OBJECTS where OBJECT_NAME like 'MC03BF0SETUP%' or OBJECT_NAME like 'MC03BX0SETUP%' or OBJECT_NAME like 'MC03UM0SETUP%';
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.