-
Trying to indx field of a table for a text search
Trying this :
create index doc_index ON tbltestintermediatextsearch(Business_Name)
indextype is ctxsys.context;
Telling me this:
ORA-29925: cannot execute CTXSYS.TEXTINDEXMETHODS.ODCIINDEXCREATE
Apparently because the appropriate system-defined role (CTXSYS or CTXAPP) is not set up.
I am just trying to index a field for a text search what or where are "CTXSYS or CTXAPP". How can I set them up ?
Thanks
Conor.
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
|