>> This is also possible, but only if you migrate not to the official
>> v2.5.2 release but to some earlier snapshot build.
>>
>> Dmitry
>>
>> One question Dimitry. We have some quite large databases and cannot do a
> backup restore cycle. Also rebuild indices may take so much time.
> What kind of indices has to be rebuilded?
> All? Compound indices? Compound indices with nullable fields?

I would say nullable compound indices, but Dmitry might have the
ultimate answer. ;-)

> If not doing backup/restore, rebuild PK indices is complicated.

The following used to work rebuilding a PK index:

alter index <pk_index> active;


The trick is to set the index active, even if it is already active. ;-)


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/