Hello all

I have recently upgraded an 8.1.7.4 database to 10gR2 on Solaris 2.9. Now,
when it was 8.1.7.4 I updated a full text index with the following command
(once the correct envrinoment had been set).

 begin
 ctx_ddl.sync_index(idx_name=>'i_gav_ft');
 end;
/
 begin

ctx_ddl.optimize_index(idx_name=>'i_gav_ft',optlevel=>ctx_ddl.optlevel_fast);

 end;

/

But now, on 10g I get the following error.

And I get the following error
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11422: linguistic initialization failed
DRG-11446: supplied knowledge base file
/usr/local/oracle/product/dora10d/ctx/data/enlx/droldUS.dat not installed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at line 2

Have things changed in 10g in the way I should refresh a full text index?

Many thanks

Farren
----------------------------------------------------------------------
The information contained in this e-mail and any subsequent
correspondence is private and confidential and intended solely
for the named recipient(s). If you are not a named recipient,
you must not copy, distribute, or disseminate the information,
open any attachment, or take any action in reliance on it. If you
have received the e-mail in error, please notify the sender and delete
the e-mail.

Any views or opinions expressed in this e-mail are those of the
individual sender, unless otherwise stated. Although this e-mail has
been scanned for viruses you should rely on your own virus check, as
the sender accepts no liability for any damage arising out of any bug
or virus infection.

John Wiley & Sons Limited is a private limited company registered in
England with registered number 641132.

Registered office address: The Atrium, Southern Gate, Chichester,
West Sussex, PO19 8SQ.
----------------------------------------------------------------------

Oracle LazyDBA home page