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.
i think u have the text installation,otherwise user wont be created...
can u please put the query u using to create index..
>create index idx_1 on emp(job) indextype is ctxsys.context;
ERROR at line 1:
ORA-29833: indextype does not exist
did u give the ctxapp role to the user from where u trying to create index.
YES ,CTXAPP has been granted.