I just dropped varchar2 (50) column full of data on a couple of tables
(approx 3 millions of records total) in my tablespace, and now I would
like to "defragment" the 10g database.
Toad 8 that I use shows tablespace Fragmentation Index = 33.57 and
when I look at tablespace map, it has many free space pieces spreaded
around whole tablespace as well as data of many tables spreaded too.
I would like to reorganize this tablespace (I can do it offline). Can
you please quide me with that?
I would also like to know the Fragmentation Index.. 33 is high
defragmentation or fair enough?
Thank you.
Received on Sat Aug 11 2007 - 14:53:07 CDT
