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!
You could do ALTER TABLESPACE tablespace_name COALESCE;
Received on Thu Feb 04 1999 - 17:04:56 CST
