'reorging' tables -Oracle 8i on NT

Hi:

I have been noticing that some of our large tables have been badly fragmented - running into hundreds of extents. Also a few of them have chained row counts of over 200 thousand. This is a vendor supplied application and the tables were not sized correctly to begin with. My task at hand is to 'reorg' the tables and size the extents and percent free correctly.

What I am finding out is that its a multiple step process in Oracle. In DB2 I'd run an ALTER and REORG to take care of data fragmentation problems.
>From what I understand in Oracle, I'd need to export the table, drop or
truncate the table , specify a high next extent size and pctfree and re-import the table.

My question are as follows:

1. Do you all automate this process and schedule to run the 'reorg' periodically or do you run them on request?
2. Is there any place in the web I can find a sample script that does the steps above?
3. What are the other methods I can use to 'reorg' oracle segments?

Thanks,
Manas.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Manas Dasgupta
  INET: manas.dasgupta_at_pfsfhq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).