REPLACE_INDEX_METADATA
Use this procedure to replace metadata in local domain indexes at the global (index) level.
Note:
The ALTER INDEX PARAMETERS command performs the same function as this procedure and can replace more than just metadata. For that reason, using ALTER INDEX PARAMETERS is the preferred method of replacing metadata at the global (index) level and should be used in place of this procedure when possible. For more information, see “ALTER INDEX PARAMETERS Syntax”.
CTX_REPLACE_INDEX_METADATA may be deprecated in a future release of Oracle Text.
Syntax
CTX_DDL.REPLACE_INDEX_METADATA(
idx_name IN VARCHAR2,
parameter_string IN VARCHAR2
);idx_name
Specify the name of the index whose metadata you want to replace.
parameter_string
Specify the parameter string to be passed to ALTER INDEX. This must begin with ‘REPLACE METADATA’.
Notes
ALTER INDEX REBUILD PARAMETERS ('REPLACE METADATA') does not work for a local partitioned index at the index (global) level. You cannot, for example, use that ALTER INDEX syntax to change a global preference, such as filter or lexer type, without rebuilding the index. Therefore, CTX_DDL.REPLACE_INDEX_METADATA is provided as a method of overcoming this limitation of ALTER INDEX. Also, ALTER INDEX REBUILD PARAMETERS ('REPLACE METADATA') does not work with forward_index; instead use 'REPLACE STORAGE'.
Though it is meant as a way to replace metadata for a local partitioned index, CTX_DDL.REPLACE_INDEX_METADATA can be used on a global, nonpartitioned index, as well.
REPLACE_INDEX_METADATA cannot be used to change the sync type at the partition level; that is, parameter_string cannot be 'REPLACE METADATA SYNC'. For that purpose, use ALTER INDEX REBUILD PARTITION to change the sync type at the partition level.