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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
