数据库做DBCC时，出现的错误，请高手帮忙看下啊。

liupaul

免费乐捐，感谢支持

Checking xlsz_d_hs
The total number of data pages in this table is 186288.
Msg 2583, Level 18, State 1:
Procedure 'neil_dump2', Line 14:
Number of data pages (186288) counted by DBCC differs from count in the data OAM
(186307) for dbid 5 object 953054431.
Table has 3870707 data rows.

那位高手能帮忙看下这个OAM错误，应该用什么方法解决啊。

flybean

try dbcc fix, or try bcp and rebuild the table

liupaul

use master
go
sp_dboption temis_pos,single,true
go
use temis_pos
go
checkpoing
go
use master
go
dbcc tablealloc(953054431,full,fix)
go
sp_dboption temis_pos,single,false
go
use temis_pos
go
checkpoint
go

完整的SQL应该是这样吧.
就是不知道,这样做了能否修复这个错误.另3870707条数据做这样的修复大概需要多长时间(联想2100的服务器,未做RAID)

还请高手帮帮忙.