Oracle WebDB Installation Guide Release 2.2 A77053-01 |
|
The chapter contains the following sections:
Oracle8i interMedia Text creates indexes that let users perform fast and accurate text searching, from traditional full-text search to document theme analysis.
The base for interMedia Text is Oracle's ConText Cartridge. For more information, see "Oracle8i interMedia Text Migration" and "Oracle8i interMedia Text Reference."
Before you integrate interMedia Text into WebDB Site Builder, you must do the following:
C:\Oracle\Ora815
.
interMedia Text in Oracle8i uses external procedures to perform document filtering. You must configure the LISTENER.ORA
, TNSNAMES.ORA
, and SQLNET.ORA
files in your Oracle8i Home directory to support these external procedures.
The LISTENER.ORA
, TNSNAMES.ORA
, and SQLNET.ORA
files on your computer should look similar to the following examples:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = my-pc)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/home) (ENVS=LD_LIBRARY_PATH=/oracle/home/lib:/oracle/home/ctx/bin: /oracle/home/bin:/oracle/home/ctx/lib) (PROGRAM= extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = /oracle/home) (SID_NAME = ORCL) ) )
ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = my-pc)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) ) )
names.initial_retry_timeout = 30 names.max_open_connections = 3 names.message_pool_start_size = 10
Before creating interMedia Text indexes in Oracle WebDB, make sure that the database has the correct DEFAULT_LEXER value defined for the language.
Follow these steps to set up a DEFAULT_LEXER value:
SELECT PRE_NAME, PRE_OBJECT FROM CTX_USER_PREFERENCES WHERE PRE_NAME = `DEFAULT_LEXER';
The value for PRE_OBJECT
returned by the above query may be any of the following:
LEXER TYPE | Description |
---|---|
BASIC_LEXER |
for single byte database |
CHINESE_VGRAM_LEXER |
for a Chinese database |
JAPANESE_VGRAM_LEXER |
for a Japanese database |
KOREAN_LEXER |
for a Korean database |
SELECT PRV_PREFERENCE, PRV_ATTRIBUTE,PRV_VALUE FROM CTX_USER_PREFERENCE_VALUES WHERE PRV_PREFERENCE LIKE `DEFAULT%'
Ensure that the language-specific attributes have correct values.
BEGIN CTX_DDL.DROP_PREFERENCE(`DEFAULT_LEXER'); CTX_DDL.DROP_PREFERENCE(`DEFAULT_WORDLIST'); CTX_DDL.DROP_STOPLIST(`DEFAULT_STOPLIST'); END;
<ORACLE8i_HOME>\ctx\admin\defaults
directory. The format of the files in this directory is drdef<language>.sql
. For example, the US script is drdefus.sql
. The Japanese script is drdefja.sql
. You must run the language-specific script in SQL*Plus as the ctxsys user.
SELECT PAR_NAME,PAR_VALUE FROM CTX_PARAMETERS WHERE PAR_NAME in (`DEFAULT_LEXER','DEFAULT_STOPLIST','DEFAULT_WORDLIST');
PAR_NAME | PAR_VALUE |
---|---|
DEFAULT_LEXER |
CTXSYS.DEFAULT_LEXER |
DEFAULT_STOPLIST |
CTXSYS.DEFAULT_STOPLIST |
DEFAULT_WORDLIST |
CTXSYS.DEFAULT_WORDLIST |
If the values returned by the query do not match those in the above table, use the CTX_ADM
package to set them. For more information, refer to the interMedia Text reference manual.
Once you have properly set up your environment for interMedia Text, you can create interMedia Text indexes in the following way:
On the WebDB Site Builder Administration page:
Note: Theme & Gists are currently supported on WebDB sites contained in English-language databases only. |
ctxcrind.sql
The following interMedia indexes are created:
Notes:
|
To update the interMedia Text indexes when you add items to your WebDB site, you must have interMedia Text Server running or you can issue the following command:
ALTER INDEX with parameters ('sync')
For more information about the interMedia Text Server and the ALTER INDEX
command, see the interMedia Text documentation.
You can drop interMedia Text indexes in either of these ways:
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|