Hello All,
I would like to know ,what will be best approach to solve fragmented table/index.Our database size is 20g.DBA before me did unlimited on tablespace and now one of the tablespace has reached to
12 g and i belive that there are lots of delete.Also we are planning
to have new servers in mar.'03.So should i wait until than to reorganize database or is there anyway which take minimal time .
1)Recreate table.
2)Rebuild Index.
3)Rebuild database.
If its rebuilding index,what will be the right steps
doing that online.Is it only one command below....

1)alter index test1 rebuild compute statistics.
i tried that on our development server.After doing for some of the index,it crash database.