Problem creating context index type

[ksarav]

Hi All ..

create index search_idx
on tb_sdw024_fct_sales(ship_to_cust_nam)
indextype is ctxsys.context

Error;
ORA-29833: indextype does not exist


There is problem in creating context index type.. i searched the net and found out that we need to run "dr0csys.sql" script which created the ctxsys users.

Anybody pls let me know if any other script needs to be run along with it and do we need to shutdown the database for running this script .

[anandkl]

Hi,
Check this link,

http://metalink.oracle.com/metalink/...Not&id=73605.1

See manual installtion on what all needs to be done to create a context index

This requires login to metalink.

regards
anandkl