Skip to Main Content

CTXSYS.CONTEXT type index creation issue.

540301Feb 4 2010 — edited Feb 11 2010
Hi All,

I am trying to create a context index as follows and it is working ok.

CREATE INDEX SMADMIN.ITX_DM_SYSOB_R_KYS ON SMADMIN.DM_SYSOBJECT_R (KEYWORDS)
INDEXTYPE IS CTXSYS.CONTEXT ;

CREATE INDEX succeeded.

But when I am adding he parameter clause as follows , I am getting below error.


CREATE INDEX SMADMIN.ITX_DM_SYSOB_R_KYS ON SMADMIN.DM_SYSOBJECT_R (KEYWORDS)
INDEXTYPE IS CTXSYS.CONTEXT parameters ('sync (every SYSDATE+5/1440)');

Error starting at line 1 in command:
CREATE INDEX SMADMIN.ITX_DM_SYSOB_R_KYS ON SMADMIN.DM_SYSOBJECT_R (KEYWORDS)
INDEXTYPE IS CTXSYS.CONTEXT parameters ('sync (every SYSDATE+5/1440)')
Error at Command Line:1 Column:23
Error report:
SQL Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexCreate
ORA-27486: insufficient privileges
ORA-06512: at CTXSYS.DRUE, line 160
ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 365
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.


Please advise to solve the issue.

Thanks
-Samar-
Comments
Post Details
Added on Feb 4 2010
3 comments
2,508 views