SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Creating Oracle Text Index giving DRG-50857: oracle error in drvxtab

91536Dec 30 2008 — edited Dec 31 2008

Hello,

I'm trying to create an Oracle text indexd as follows:

Create index tt.idx_emp on tt.emp(emp_name)
Indextype is ctxsys.context
Parameters(‘
Datastore idx_emp_dst
Filter idx_emp_fil
Section group idx_emp_sgp
Lexer idx_emp_lex
Wordlist idx_emp_wdl
Stoplist idx_emp_spl
Storage idx_emp_sto
Sync (on commit)
‘)
/

But, I get the following error:

Create index tt.idx_emp
*

ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-00905: missing keywork
ORA-06512: at “CTXSYS.DRUE”, line 160
ORA-06512: at “CTXSYS.TEXTINDEXMETHODS”, line 364

Has anyone encountered this error before? What did you do to fix this?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 28 2009

Added on Dec 30 2008

1 comment

1,198 views