环境ASE 12.5.4 WINDOWS
库名test
大小2M
表名pet_goods
dump文件test.dump
步骤:
1 建一个2M的库test,实现方法随便大家
2 load database test from 'test.dump'
3 online database test
4 bcp test..pet_goods out pet_goods.bcp -c -Usa -Pxxxx
你会发现你的bcp一直都不会结束,直到你中断
dbcc checktable(pet_goods)
--------------------------------------
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=631; page# pointing to this page=678; previous page# indicated
in this page=630)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
--------------------------------------作者: andkylee 时间: 2010-08-13 14:46 本帖最后由 andkylee 于 2010-08-13 14:50 编辑
1> dbcc pglinkage(5,633,0,2,0,1)
2> go
Object ID for pages in this chain = 32000114.
Page : 633
Page : 634
Page : 635
Page : 636
Page : 637
Page : 638
Page : 639
Page : 624
Page : 625
Page : 626
Page : 627
Page : 628
Page : 629
Page : 630
Page : 631
Page : 672
Page : 673
Page : 674
Page : 675
Page : 676
Page : 677
Page : 678
Page : 631
pprevpg pointer for page 631 does not point to previous page in chain
as scanned. pprevpg pointer = 630, previous page as scanned = 678.
23 pages scanned. Object ID = 32000114. Last page in scan = 631.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1>