SQL Error: ORA-29855: Error in executing ODCIINDEXCREATE routine

Asked

Viewed 252 times

0

I’m trying to create an index on Oracle where it will be automated and run every hour. Query:

CREATE INDEX IX_TXT_NOME ON TBL_PESSOA ("TXT_PESSOA") 
INDEXTYPE IS "CTXSYS"."CONTEXT"
PARAMETERS ('DATASTORE CTXSYS.DEFAULT_DATASTORE SYNC (EVERY SYSDATE+60/1440)')

When executing the error is shown:

Erro de SQL: ORA-29855: ocorreu um erro na execução da rotina ODCIINDEXCREATE
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexCreate
ORA-27486: privilégios insuficientes
ORA-06512: em "CTXSYS.DRUE", line 160
ORA-06512: em "CTXSYS.TEXTINDEXMETHODS", line 366
29855. 00000 -  "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause:    Failed to successfully execute the ODCIIndexCreate routine.
*Action:   Check to see if the routine has been coded correctly.
oracle oracle11g oracle10g

  • The user who tried to do the operation should not have the privilege of creating indexes. https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5010.htm

1 answer

0

Browser other questions tagged oracle oracle11g oracle10g

You are not signed in. Login or sign up in order to post.