Rebuilding an Index

You can rebuild a valid index using ALTER INDEX. You might rebuild an index when you want to index with a new preference.

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

Example

The following command rebuilds the index, replacing the lexer preference with my_lexer.

ALTER INDEX newsindex rebuild parameters('replace lexer my_lexer');