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?

----------------------------------------------------------------------

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 07:40:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.