Sybase数据库技术，数据库恢复专家

在公司测试环境上执行sp_spaceused时报error：1151的错误。虽然这不是一个严重的错误，记得好像以前也出现过一次，故记录一下。

1> sp_spaceused
2> go
 database_name                                      
         database_size                                       
 ----------------------------------------------------
         ----------------------------------------------------
 ultranms                                           
         600.0 MB                                            

(1 row affected)
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
 reserved                         data                       
         index_size                               unused                      
 -------------------------------- ----------------------------
         ---------------------------------------- ----------------------------
 9020 KB                          1396 KB                    
         1064 KB                                  6560 KB                     
(return status = 0)
 

出现错误1151的原因是：执行sp_spaceused统计数据库的空间使用情况的时候，其它会话正在执行删除表的操作。

阅读全文...