Oracle Text Reference Release 9.2 Part Number A96518-01 |
|
This chapter provides reference information for using the CTX_ADM
PL/SQL package to administer servers and the data dictionary.
CTX_ADM
contains the following stored procedures:
Name | Description |
---|---|
Cleans up database objects for deleted Text tables. |
|
Sets system-level defaults for index creation. |
|
Shuts down a single |
The RECOVER
procedure cleans up the Text data dictionary, deleting objects such as leftover preferences.
CTX_ADM.RECOVER;
begin ctx_adm.recover; end;
You need not call CTX_ADM.RECOVER
to perform system recovery if ctxsrv servers are running; any ctxsrv servers that are running automatically perform system recovery approximately every fifteen minutes. RECOVER
provides a method for users to perform recovery on command.
The SET_PARAMETER
procedure sets system-level parameters for index creation.
CTX_ADM.SET_PARAMETER(param_name IN VARCHAR2, param_value IN VARCHAR2);
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. |
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[M|G|K]
where M stands for megabytes, G stands for gigabytes, and K stands for kilobytes.
For each of the other parameters, specify the name of a preference to use as the default for indexing.
begin ctx_adm.set_parameter('default_lexer', 'my_lexer'); end;
The SHUTDOWN
procedure shuts down the specified ctxsrv server.
CTX_ADM.SHUTDOWN(name IN VARCHAR2 DEFAULT 'ALL', sdmode IN NUMBER DEFAULT NULL);
Specify the name (internal identifier) of the ctxsrv server to shutdown.
Default is ALL.
Specify the shutdown mode for the server:
Default is NULL.
begin ctx_adm.shutdown('DRSRV_3321', 1); end;
If you do not specify a ctxsrv server to shut down, CTX_ADM.SHUTDOWN
shuts down all currently running ctxsrv servers.
The names of all currently running ctxsrv servers can be obtained from the CTX_SERVERS
view.
|
Copyright © 1998, 2002 Oracle Corporation. All Rights Reserved. |
|