|Oracle8i interMedia Text Migration
Release 2 (8.1.6)
Part Number A77061-01
Indexing, 8 of 14
In pre-8.1, when an indexing operation fails (creation or optimization), you can resume the operation using CTX_DDL.RESUME_FAILED_INDEX.
In interMedia Text 8.1, you resume a failed index creation operation using the ALTER INDEX command.
Optimization in 8.1 commits at regular intervals. Therefore if optimization fails, all optimization work has already been saved.
To learn more about the ALTER INDEX command syntax, see the Oracle8i interMedia Text Reference.
The following command resumes the indexing operation on
newsindex with 2 megabytes of memory: