empty token table (DR$...$I) after creating ctxsys.content index
Hi,
I createe a fulltext index on a blob colum but I didn't get results after a contains query. The DR$...$I table was not populated.
This problem I get only with Oracle 19.3 SE2 on Windows Server 2016. It works on these configurations:
- Oracle 19.3 SE2 on Oracle Linux 7
- Oracle 12.1 EE and SE2 on Windows Server 2012
Here are the details of my tests:
create user user1 identified by oracle9i;grant connect,resource to user1;alter user user1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;ALTER USER user1 QUOTA UNLIMITED ON USERS;
BEGIN ctx_ddl.create_preference('user1.lex', 'BASIC_LEXER'); ctx_ddl.set_attribute ( 'user1.lex', 'mixed_case', 'NO');END;/create table user1.fulltext_index_test(identifier number(38) primary key, file_colum blob);insert into user1.fulltext_index_test values (-1,null);commit;