Resuming Failed Index

Pre-8.1

In pre-8.1, when an indexing operation fails (creation or optimization), you can resume the operation using CTX_DDL.RESUME_FAILED_INDEX.

8.1

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.

See Also: To learn more about the ALTER INDEX command syntax, see the Oracle8i interMedia Text Reference.

Example

The following command resumes the indexing operation on newsindex with 2 megabytes of memory:

ALTER INDEX newsindex rebuild parameters('resume memory 2M');