Database Software

Hi

I'm experimenting with theme indexing documents with a new thesaurus/taxonomy.

I've loaded the new thesaurus successfully with ctxload as follows

ctxload -user ctxsys/********* -thes -name IPSV -thescase n -file IPSV_Full_Padded.TXT

and compiled it successfully

ctxkbtc -user ctxsys/********* -name IPSV
Oracle Text knowledge base extension: thesaurus compiler
Connecting...
No old extended knowledge base to delete.
Processing thesaurus: IPSV
Processed 7902 terms.
......
Done processing thesaurus: IPSV
Compiling and writing new flat files.
Writing extended knowledge base to files.
.............................................
,,,,,,,,,,,
................................................................................
....................................................
Oracle Text knowledge base successfully extended.


and I can view the terms in DR$THS_PHRASE.

I have indexed the documents using

BEGIN
ctx_ddl.create_preference('CoL_lexer','basic_lexer');
ctx_ddl.set_attribute('CoL_lexer','index_themes','yes');
END;

and then

CREATE INDEX CoL_idx ON CoL_docs(document)
INDEXTYPE IS ctxsys.context
PARAMETERS('lexer CoL_lexer sync (on commit)');

All OK so far, however when I look at the themes using

BEGIN
delete from col_full_theme_res;
ctx_doc.themes('CoL_idx', '1', 'CoL_full_theme_res', 1, TRUE);
ctx_doc.themes('CoL_idx', '2', 'CoL_full_theme_res', 2, TRUE);
ctx_doc.themes('CoL_idx', '3', 'CoL_full_theme_res', 3, TRUE);
ctx_doc.themes('CoL_idx', '4', 'CoL_full_theme_res', 4, TRUE);
commit;
END;

I find that the only themes identified are from the default knowledge base and not the extended one.

Has anyone come across this before?

Can I remove the default knowledge base easily? (I would need to restore it later)

I'm using Oracle 10.2.0.1 on Solaris 10 (x64)

Many thanks

Brian