A few weeks back, I had published a script that will dynamically create a reorg script and execute it. Now I have made few modifications to it. The new script does couple of things more :
- It has an exclude list . Any table name or index name will be excluded from the reorg script
- It now includes the “USE” temporary tablespace feature.
- It will also email the reorg report to an email address
Offline or classic reorgs are much faster and lot more efficient. It however needs exclusive access to the table. Here is a new script : reorg.zip The zip has two files, one is the reorg script and the other one is called from the reorg.sh that generates the report.