Re: Index tablespace reorg

Unknown wrote:
>
> Greetings all -
>
> I have a slew of indexes in a tablespace that I wish to reorganize
> (and increase in size). I don't want to use ALTER TABLESPACE ADD DATAFILE
> as I would rather just make a new, single file to hold all the information.

All of the solutions mention here will work(including yours). "Alter index rebuild" will only
work with 7.2 or better. When you recreate your indexes make the next parameter larger so they don't
defrag so easy.

Charles Walker
Computer Scientist
Computer Sciences Corp Received on Wed Jan 29 1997 - 00:00:00 CST