Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement