Re: Change chunk name

Posted in 2005

Art S. Kagel — Thu, 28 Jul 2005 12:24:59 -0400 — source: Usenet: comp.databases.informix

GG wrote: > Hello > > I would like change chunk name: > > 1804efc0 10 3 0 1048575 465172 PO- > /u/informix/chunki/c3 > > from c3 to c10. If you can reorg the tables which have extents in that chunk such that there are no longer any extents in the c3 chunk (perhaps by reorging tables into a different dbspace temporarily - even one you create specially just for this reorg), then you can drop the c3 chunk and add the c10 chunk to the dbspace instead. Then if you have to you can move the data back. Art S. Kagel > c3 is symbolic link to soft partition (md device). > Now on the c3 are extents from my databases (is no free). > Is possible do it don't export data from c3 and import to c10 ? > > ( Is possible make new link c10 to the same soft partition > and reconfigure IDS to using c10 instead of c3 ? > ) > > I'm using IDS 7.31 on Solaris > Thanks in advice > > GG > >