Oracle全文检索方面的研究(全2)(2)

insert into hdocs values(1, binary, /docs/myword.doc);

insert in hdocs values (2, text, /docs/index.html);

insert in hdocs values (2, ignore, /docs/1.txt);

commit;

create index hdocsx on hdocs(text) indextype is ctxsys.context

parameters (datastore ctxsys.file_datastore filter ctxsys.auto_filter format column

fmt);

3.2.4 MAIL_FILTER

通过mail_filter 把RFC-822,RFC-2045 信息转化成索引文本

限制：

文档必须是us-ascii

长度不能超过1024bytes

document must be syntactically valid with regard to RFC-822

3.2.5 USER_FILTER

Use the USER_FILTER type to specify an external filter for filtering documents in a column

3.2.6 PROCEDURE_FILTER

Use the PROCEDURE_FILTER type to filter your documents with a stored procedure. The stored procedure is called

each time a document needs to be filtered.

3.2.7 参考脚本

--建立null filter

create index myindex on docs(htmlfile) indextype is ctxsys.context

parameters(filter ctxsys.null_filter section group ctxsys.html_section_group);

--建立 auto filter

Create index idx_m_filter on my_filter (docs) indextype is ctxsys.context

parameters (datastore test_filter filter ctxsys.auto_filter);

Filter 错误记录表：CTX_USER_INDEX_ERRORS