Kbase P101241: Unable to Apply incremental df with no integrity (-i) because bi file exceeded 2 GB.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/02/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.x
SYMPTOM(s):
Applying incremental df with no integrity (-i).
Dropping a field from a very large table.
bi file exceeded 2 GB.
CAUSE:
Table that contained the field to be dropped was over 3 GB in size and even though no integrity was being used the bi exceeded 2 GB cause the incremental to abort.
FIX:
The current database will have to be restored from backup because integrity was turned off before anything can be done.
1. Recreate the original database structure (without data).
2. Apply incremental df to drop the field.
3. Dump data from the original restored database, however, on the one table where the field is being dropped, do not dump the information for that field.
4. Load data into new structure.