Re: Index tablespace reorg

From: Atul Ashar <Atul_Ashar_at_ccmail.bms.com>
Date: 1997/01/30
Message-ID: <32F0CA58.D4E@ccmail.bms.com>#1/1

Charles Walker wrote:
>
> 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

If your question is how to increase size of tablespace without adding new datafiles then you can resize your existing datafile to make it larger. This way you can avoid adding files to existing tablespace.

Refer to SQL Reference manual for further details. Received on Thu Jan 30 1997 - 00:00:00 CST