My tablespace is heavily fragmented. I guess.
I have 30 datafiles for this tablespace.
Each datafile has 1 GIG.
Out of the 1 GIG per datafile, only 30 -50 %
is used.
I have come to a conclusion that the spaces
are not contigous. Also the tablespace has
250 tables(big, medium and small). Also most
of the small to medium tables has a lot of
extents.


This is what I have decided to do:
1.Export the entire database with compress=y
NOTE:The only table with a lot of extents
is 650M.
2.Drop all the tables/truncate the
tables with drop storage
3.Import all entire database

What do you guys think about this approach?