5 CTX_ADM Package

RECOVER

The RECOVER procedure cleans up the Text data dictionary, deleting objects such as leftover preferences.

Syntax

CTX_ADM.RECOVER;

Example

begin
   ctx_adm.recover;
end;

SET_PARAMETER

The SET_PARAMETER procedure sets system-level parameters for index creation.

Syntax

CTX_ADM.SET_PARAMETER(param_name IN VARCHAR2,
                      param_value IN VARCHAR2);

param_name

Specify the name of the parameter to set, which can be one of the following:

• max_index_memory (maximum memory allowed for indexing)

• default_index_memory (default memory allocated for indexing)

• log_directory (directory for CTX_OUPUT files)

• ctx_doc_key_type (default input key type for CTX_DOC procedures)

• file_access_role

• default_datastore (default datastore preference)

• default_filter_file (default filter preference for data stored in files)

• default_filter_text (default text filter preference)

• default_filter_binary (default binary filter preference)

• default_section_html (default html section group preference)

• default_section_xml (default xml section group preference)

• default_section_text (default text section group preference)

• default_lexer (default lexer preference)

• default_wordlist (default wordlist preference)

• default_stoplist (default stoplist preference)

• default_storage (default storage preference)

• default_ctxcat_lexer

• default_ctxcat_stoplist

• default_ctxcat_storage

• default_ctxcat_wordlist

• default_ctxrule_lexer

• default_ctxrule_stoplist

• default_ctxrule_storage

• default_ctxrule_wordlist

  
  

  See Also: To learn more about the default values for these parameters, see "System Parameters" in Chapter 2.

  
  

param_value

Specify the value to assign to the parameter. For max_index_memory and default_index_memory, the value you specify must have the following syntax:

number[K|M|G]

where K stands for kilobytes, M stands for megabytes, and G stands for gigabytes.

For each of the other parameters, specify the name of a preference to use as the default for indexing.

Example

begin
  ctx_adm.set_parameter('default_lexer', 'my_lexer');
end;