You may also zap the original table and append from the copy.
>We have a huge file which regularly approaches the 2GB limit. The system is being rewritten to use an Oracle back-end but needs regular TLC in the interim.
>
>The procedures here are to
>
>1. Save the index tags to an array
>2. Copy the older records to a temp table
>3. Delete those records
>4. Delete all the index tags
>5. PACK the tables (should bring the size down from 1.9 GB to 1.6 GB)
>6. Rebuild each index tag separately from the array
>
>The archive file is also growing rather large (1.25 GB at the moment). Prior to APPENDing from the temp table, they also DELETE the index tags and then rebuild them.
>
>There are anywhere from 10 to 30 tags involved on the tables involved in this process.
>
>Is there any performance or safety reason for doing this? Are there any reasons to avoid doing something like this?
>
>Thanks..........Rich
If it's not broken, fix it until it is.
My Blog