Kbase P12862: Attempting Tablemove generates 8600 error.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
Error using tablemove utility.
WARNING - tablemove not allowed with inactive index. (8600)
CAUSE:
The table contains an inactive index and can not be moved.
FIX:
A table with an inactive index cannot be moved.
To determine what indexes are inactive for a table, connect to the database via Data Dictionary and run a Detailed Table report.
Find all inactive indexes in the listing and use the "proutil dbname -C idxbuild" command to rebuild the inactive indexes making them active or delete the inactive indexes.
The table can be moved after all indexes have been activated.