sybase数据库空间不足时扩库

4524阅读 0评论2010-03-11 2008sgh
分类:Sybase

 
 
 
isql -Uusername -Ppassword -Sservicename
go
 
 
use master
go
 
disk init name = 'dbname_data_03', physname = '/opt/sybase/data/dbname_data_03.dat',size = '400M', dsync = false
 
go    //如果size较大,会比较慢的.

disk init name = 'dbname_log_03',physname = '/opt/sybase/data/dbname_log_03.dat',size = '400M', dsync = false
 
go
 
use master
go
 
alter database dbname on dbname_data_03 = 400  log  on dbname_log_03 = 400
上一篇:在FreeBSD环境下安装Sybase 11.0.3.3
下一篇:you may be a victim of software counterfeiting