Home » Server Options » Text & interMedia » Priviledges on creating index
Priviledges on creating index [message #75897] Thu, 06 December 2001 08:17 Go to next message
martin samm
Messages: 1
Registered: December 2001
Junior Member
when i create an index using the following command :

create index im_art_s_idx_2 on article(cl_story)
indextype is ctxsys.context;

i get the following errors

create index im_art_s_idx_2 on article(cl_story)
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1

I can quite happily create a normal index on that table and intermedia seems to be installed okay. Any ideas?

----------------------------------------------------------------------
Re: Priviledges on creating index [message #75916 is a reply to message #75897] Thu, 07 March 2002 00:08 Go to previous message
ravibabu
Messages: 12
Registered: July 2001
Junior Member
user should have ctxapp role.You have to grant this role to that user.
Previous Topic: intermedia installation and create index on XML in Clob field
Next Topic: Re: Error while creating context index ( platform window NT)
Goto Forum:
  


Current Time: Thu Mar 28 18:47:16 CDT 2024