Re: Recreating unique indices without having dups & downtime.

You should just be able to create the same index with a different name, 
then drop the original.  I don't think there are any conflicts with indexes 
with the same structure, as long as they have different names.  I've never 
actually tried this myself  though.

If the DTD problem within transactions was fixed in 7.0x, you might even be 
able to do this within a transaction.  I don't remember hearing that DTD 
operations were now reliable within transactions with the 7.0 release 
announcement though.

At 11:34 AM 7/9/00, Denis Perchine wrote:
>Hello,
>
>Is it possible to recreate unique indices without having dups (in the case 
>of drop/create),
>or downtime (in the case of reindex)? This is real problem.
>
>--
>Sincerely Yours,
>Denis Perchine
>
>----------------------------------
>E-Mail: dyp@perchine.com
>HomePage: http://www.perchine.com/dyp/
>FidoNet: 2:5000/120.5
>----------------------------------