sybase>$isql -Usa


use master
go


# size 단위는 block (1024 = 2M) 이다. 500000 은 약 1G
disk init name = "TMS_DEV", physname = "/datafile/sybase/dev/TMS_DEV.dat", size = 500000
go

disk init name = "TMS_LOG", physname = "/datafile/sybase/dev/TMS_LOG.dat", size = 50000
go


# size 단위는 Mbyte
create database TMS on TMS_DEV = 1024 log on TMS_LOG = 100
go


sp_addlogin tmsadmin, tmsadmin, TMS
go


use TMS
go

sp_changedbowner tmsadmin, true
go

use master
go
sp_dboption TMS, "trunc log on chkpt", true
go

use TMS
go
checkpoint
go

use master
go
sp_dboption TMS, "allow nulls by default", true
go

use TMS
go    
checkpoint
go

use master
go 
sp_dboption TMS, "select into/bulkcopy/pllsort", true
go

use TMS
go
checkpoint
go

use master
go
sp_dboption TMS, "abort tran on log full", true
go

use TMS
go
checkpoint
go



내 남자의 길~! 블로그를 구독하고 싶으시면 Click --->


TAG
1 2 3 4 5 6 7 8 9 10 ··· 13 

글 보관함

카운터

Total : 1,706,199 / Today : 58 / Yesterday : 217
get rsstistory!