General information
Category:
Coding, syntax & commands
>You may also zap the original table and append from the copy.
>
Not really relevant in our case. The older records are copied out and purged from the original table and are then appended into an existing archive.
>Also please check your private messages.
Got it........Thanks!!!!
>
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only