专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > Sybase

急高分!

发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
急!在线等,高分求助!!!!
未学过SYBASE,但赶鸭子上架,被逼维护数据库。
观察出错情况如下:
Can't allocate space for object 'master_log' in database 'foxhis' because the 'default' segment is full. IF you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
通过dump trabsaction foxhis with truncate_only清除日志后,用sp_helpdb foxhis查看结果如下:
 name db_size owner dbid  
  created  
  status  
 ------------------------ ------------- ------------------------ ------ 
  -------------- 
  ------------------------------------------------------------------ 
 foxhis 1702.5 MB foxhis 5
  Nov 12, 2001  
  select into/bulkcopy, trunc log on chkpt, allow nulls by default  

 device_fragments size usage free kbytes 
 ------------------------------ ------------- -------------------- ----------- 
 foxhis 1000.0 MB data only 0 
 foxhis1 1.5 MB data only 0 
 foxhis2 1.0 MB data only 0 
 foxhis3 500.0 MB data only 0 
 foxlog 200.0 MB log only 204784 

 device  
  segment  
 ------------------------------ 


通过sp_helpdevice
1> sp_helpdevice
2> go
 device_name physical_name  
  description  
  status cntrltype device_number low high  
 ------------------------------ ---------------------------------------------- 
  ---------------------------------------------------------------------------------------------------------- 
  ------ --------- ------------- ----------- ----------- 
 foxdump /backup/dump/foxdump.dat  
  disk, dump device  
  16 2 0 0 0 
 foxhis /dev/rfoxhis  
  special, physical disk, 1000.00 MB  
  2 0 2 33554432 34066431 
 foxhis1 data1foxhis1.dat  
  special, physical disk, 1.95 MB  
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: