DM8全文索引使用测试过程如下：

1.创建用户：

create user person identified by Dameng123;
grant dba to person;

2.创建测试表：

create table person.address(id int,address1 varchar(20));
insert into person.address values(1,'xxx');
insert into person.address values(2,'bbbbb');
insert into person.address values(13,'cccccc');
insert into person.address values(5,'sdfsdf');
commit;

3.创建全文索引，比如testidx

create context index testidx on person.address(address1) lexer default_lexer;
select * from person.cti$testidx$i;
select * from person.cti$testidx$p;
select * from person.cti$testidx$n;
select * from person.cti$testidx$d;

此时查询上述记录为空。
执行全文索引更新后，

alter context index testidx on person.address rebuild;
select * from person.cti$testidx$i;
select * from person.cti$testidx$n;

可以查到记录。

全文索引更新

ALTER CONTEXT index testidx on person.address rebuild;

更新增加全文索引信息

ALTER CONTEXT INDEX testidx ON PERSON.ADDRESS INCREMENT;

删除全文索引

drop context index testidx on "PERSON"."ADDRESS";

查看全文索引：

Select * from ctisys.syscontextindexes;

4.测试查询：

insert into person.address values(6,'aaa aaa ffff');
insert into person.address values(7,'sdf sdf');
commit;

ALTER CONTEXT INDEX testidx ON PERSON.ADDRESS INCREMENT;
select * from person.address where contains(address1 ,'xxx' or 'sdf' or 'c');