-
Oracle Text installation
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.
Prasad
-
i think u have the text installation,otherwise user wont be created...
can u please put the query u using to create index..
regards
Saurabh Garg
OCP 9i
-
>create index idx_1 on emp(job) indextype is ctxsys.context;
ERROR at line 1:
ORA-29833: indextype does not exist
Prasad
-
hi,
did u give the ctxapp role to the user from where u trying to create index.
regards
Saurabh Garg
OCP 9i
-
YES ,CTXAPP has been granted.
Prasad
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|