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 ?
Click Here to Expand Forum to Full Width