Oracle Text installation

[prasadvd]

hi all,

we have 9.0.1 db on win2k3. It contains CTXSYS user belongs to
Oracle Text. I am not able to create index using oracle text syntax.
I think oracle text has n't been installed .So, how to install it ?
Earlier we have migrated db from 8.1.5 to 9.0.1.


Thanks for adv.

[saurabhg29]

i think u have the text installation,otherwise user wont be created...

can u please put the query u using to create index..

regards

[prasadvd]

>create index idx_1 on emp(job) indextype is ctxsys.context;

ERROR at line 1:
ORA-29833: indextype does not exist

[saurabhg29]

hi,

did u give the ctxapp role to the user from where u trying to create index.

regards

[prasadvd]

YES ,CTXAPP has been granted.