Re: Rename a dbspace

Posted in 2003

Umberto Quaia — Sat, 30 Aug 2003 01:14:21 +0200 — source: Usenet: comp.databases.informix

> On Wed, 13 Aug 2003 05:43:51 -0400, Oxow wrote: > > Does someone know an easy mean which permit me to rename a dbspace > > contening just a separated index ? > > Fred "Art S. Kagel" <kagel@bloomberg.net> answered: > > 1- drop the index > 2- drop the dbspace > 3- create the new dbspace with desired name > 4- recreate the index. > > That really is the easiest way. > > Art S. Kagel Almost right. There is an easier one: 1- create new dbspace 2- ALTER FRAGMENT ON index INIT IN newdbspace ; to relocate index 3- drop old dbspace ;-) Umberto Quaia

Related threads

Different instances with markedly different times