errors, need some help

From: <jimi_xyz_at_hotmail.com>
Date: 18 Jul 2005 10:11:59 -0700
Message-ID: <1121706719.017252.301380@f14g2000cwb.googlegroups.com>

hello,
Im starting to just get into oracle text, and I seem to be getting a error when i index my table...

SQL> create index idxmytable
  2 on mytable(doc2search)
  3 indextype is ctxsys.context
  4 parameters('sync(on commit)');
create index idxmytable
*
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11000: invalid keyword SYNC(ON
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 219

Im not asking for someone to figure out the problem for me, just set me out on the path. Please no wise @ss remarks either.

Thank you,
Jimmie Received on Mon Jul 18 2005 - 12:11:59 CDT