Hi,

I am creating an Context based index with the following syntax:

CREATE INDEX Index_Name ON Table_Name(Column_Name)
INDEXTYPE IS CTXSYS.CONTEXT parameters('STORAGE NEWCTXINDEXSTORE');

Datatype OF COLUMN Name IS: VARCHAR2(256).

AND I am USING TOAD Tool.

I am getting the following error.


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: NEWCTXINDEXSTORE
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 186
some times I am getting this error also
DRG-50857: oracle error in drekmap (execute insert).

Can we create like this (Observe Parameters Storage clause with 'CTXINDEXSTORENEW')

CREATE INDEX Index_Name ON Table_Name(Column_Name)
INDEXTYPE IS CTXSYS.CONTEXT parameters('STORAGE CTXINDEXSTORENEW');

OR

Storage Clause with 'CTXINDEXSTORE'

CREATE INDEX Index_Name ON Table_Name(Column_Name)
INDEXTYPE IS CTXSYS.CONTEXT parameters('STORAGE CTXINDEXSTORE');
I am new to this Topic.

Can any body help me.

Thanks in Advance,
Sankar G