Re: Rebuilding Indexes

Hi

    just to make sure

        alter tablespace <tablespace_name> coalesce;

   hope this help..
pradhan

Jeanne wrote:

> We are doing an application upgrade that requires dropping and
> re-creating every application index in the database. After dropping all
> indexes for a tablespace (which only contained indexes), is there any other
> maintenance needed in the tablespace? Would there be anything to gain my
> dropping and recreating the tablespace, or is it pretty much initialized at
> that point?
> Thanks so much for any replies!
Received on Wed Feb 03 1999 - 21:52:05 CST