Oracle Text (MOSC)

MOSC Banner

empty token table (DR$...$I) after creating ctxsys.content index

edited Jan 31, 2020 7:45AM in Oracle Text (MOSC) 2 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center