Re: reorg of Oracle10g tablespace in offline mode

Joe wrote:
> 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.

And you have determined there is fragmentation by what means?

Please show us the SQL statement(s) and the metrics retrieved.

33.57 is a measure of what?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org