I have some really big indexes that need to be recreated. My question
is, once I drop the index, should I coalesce the tablespace it was in
before I recreate it? I'm asking this question because I saw a script
once that had this procedure but I'm not really sure of the total
ramifications of coalescing a tablespace. FYI, I'm running Oracle 8.0.6
and the only segment in the tablespace is the index in question. Any
on all replies. Thanks.