Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Corrupt index how to rebuild safely on large table
Message
 
À
12/11/1998 14:08:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00157066
Message ID:
00157264
Vues:
19
>>>I have a foxpro 2.6 table with over 800,000 records in it. When I do a reindex or pack on it, what appears to be an infinite loop of indexing happens. I have let the table reindex for over an hour and it just keeps on reindexing (more than the number of individual indexes on the cdx file). Has anyone seen this behaviour?
>>>
>>>What is a safe way to rebuild the CDX? Should I delete all of the indexs (using the table properties screen) then delete the CDX file, then create a new one? Or can I simply delete the CDX? I don't want to corrupt this table.
>>
>>DELETE TAG ALL and then rebuild tags.
>
>Evan,
>
>This is the safest way, except if you have lots of complex tags. If so, make sure you know exactly how to recreate them. You can run your database through gendbc to get these listings (or use my gentable program here in the files section). Just a word of caution on something that has burned me before.

Hello folks!

How about corrupt MEMO file? We have FP2.6 hospital project with 1M+ records on the transaction child table. Downloads from UT's file are not working properly to this problem. Is there any new approach?? That corrupted and unusable table is currently dumped and we temporarily replaced it with a new one just for the operation to go on. Trouble is how can we be able to retrieved the records from the former one??

TIA
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform