求助：dbcc检测结果

hdg11

数据库为ASE12.5，操作系统redhat linux as3，近期运行dbcc checkdb(db)出现如下错误，请问如何解决。错误信息如下：
Number of data pages (1736) counted by DBCC differs from count in the data OAM (1735) for dbid 5 object 542621945.
Index i_u_tranctrl is not consistent; found 29493 leaf rows but 29482 data rows. Drop and recreate the index.
Index i_u_tranlog is not consistent; found 32995 leaf rows but 33019 data rows. Drop and recreate the index.
Number of data pages (8609) counted by DBCC differs from count in the data OAM (8599) for dbid 5 object 713050545.
Index i_u_sale_h1 is not consistent; found 128491 leaf rows but 128678 data rows. Drop and recreate the index.
Index i_u_sale_h_11 is not consistent; found 229 leaf rows but 240 data rows. Drop and recreate the index.
Index i_u_sale_h_13 is not consistent; found 118 leaf rows but 119 data rows. Drop and recreate the index.
Index i_u_sale_d_11 is not consistent; found 371 leaf rows but 402 data rows. Drop and recreate the index.
Index i_u_sale_h_16 is not consistent; found 111 leaf rows but 134 data rows. Drop and recreate the index.

hobbylu

对这个表重新建索引就可以了

hdg11

可以使用reorg rebuild 表名来修复吗？

chuxu

Drop and recreate the index