Kbase P16719: How to eliminate duplicated keys or records.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2009 |
|
Status: Verified
GOAL:
How to eliminate duplicated keys or records.
GOAL:
How to get ride of duplicated records.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.x
Progress 8.x
FIX:
If the primary index is set as unique do the following:
1.- Make a backup of the DB.
2.- Dump the records and definition for that table.
3.- Delete the table.
4.- Load the definitions and the records for the table.
Since the duplicate records were not in the index, they can't fetched by the dump (export). Just the original records will be dumped and reloaded with this process.
Note: Binary or dictionary dumps will use the primary index by default.