SYBASE IQ DBFILE 迁移

wangdonsy

--查看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 file  iq_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

不错不错，学习了