Re: reorg of Oracle10g tablespace in offline mode

On Sat, 11 Aug 2007 12:53:07 -0700, Joe <joe1977_at_tlen.pl> 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.

Please explain what you are trying to accomplish with your defragmentation action. If you are running on locally managed tablespaces, your tablespaces won't get fragmented, ever. Please also note Toad 8.0 is way old. newer versions of Toad (the most current one is 9.1.0) won't show any fragmentation,as locally managed tablespaces can't fragment.
Finally the 'fragmentation index' you refer to is a measure Quest made up. They have a group for Toad in yahoogroups.com. I suggest you direct your query there, but as far as I am concerned you are wasting your time.

-- 
Sybrand Bakker
Senior Oracle DBA