strange occurences on Intermedia (8.1.6) on Solaris 7 vs win2k

Hi!
I have ome strange occurences on Intermedia (8.1.6) on Solaris 7! I had no problems on my testing environment 8.1.6 & win2k!

Table t_search with column body as a BLOB (can be Word, PDF, *.txt)

<sqlplus>
create index T_SEARCH_IDX on t_search ( body ) indextype is ctxsys.context
parameters ('FILTER ctxsys.inso_filter LEXER german_lexer MEMORY 262144');
COMMIT; Index created.
</sqlplus>

seemed ok!

But any query-string returns nothing

> SELECT SCORE(1) brabbit from t_search WHERE CONTAINS(body, 'der', 1) > 0;

->no rows returned!!!

Occurence 1:
############

>select * from ctx_user_index_errors;

-> many entries in column ERR_TXT: "DRG-11207: user filter command
exited with status 137"

Occurence 2:
############

-> I drop the index each time i run my pl/sql-script by putting this
in front of all actions:

<sqlplus>
DROP INDEX T_SEARCH_IDX;
</sqlplus>

but DBMS_OUTPUT always complains:

• ERROR at line 1: ORA-01418: specified index does not exist

Curious, isn't it?

Can somebody explain or help me out of this trouble?

thx Stefan Received on Thu Jan 23 2003 - 05:29:56 CST