论坛 › Sybase › SYBASE IQ DBFILE 迁移

wangdonsy 发表于 2011-02-10 11:48

SYBASE IQ DBFILE 迁移

--查看dbfile 信息
sp_iqfile

--添加一个dbfile
alter dbspace iq_main add file newiq_main'newiq_main.iq' size 75MB reserve 200MB
alter dbspace IQ_SYSTEM_MAIN add file newiqdemo_main'newiqdemo_main.iq' size 25MB reserve 200MB
alter dbspace IQ_SYSTEM_TEMP add file newiqdemo_temp'newiqdemo.iqtmp' size 13MB reserve 0MB

--设置原dbfile 为只读模式
alter dbspace iq_main alter fileiq_main READONLY
alter dbspace IQ_SYSTEM_MAIN alter file IQ_SYSTEM_MAIN READONLY
alter dbspace IQ_SYSTEM_TEMP alter file IQ_SYSTEM_TEMP READONLY

--清空原dbfile ,temp file 不用
sp_iqemptyfile 'iq_main'
sp_iqemptyfile 'IQ_SYSTEM_MAIN'

--删除iq_main file
alter dbspace iq_main drop file iq_main
alter dbspace IQ_SYSTEM_MAIN drop file IQ_SYSTEM_MAIN
alter dbspace IQ_SYSTEM_TEMP drop file IQ_SYSTEM_TEMP

zq5143 发表于 2011-02-14 14:15

不错不错，学习了

查看完整版本: SYBASE IQ DBFILE 迁移