This discussion is archived
4 Replies Latest reply: Jun 8, 2012 6:14 AM by user13780543 RSS

ERROR while syncing the Text Index

user13780543 Newbie
Currently Being Moderated
Hi All,

We are facing an issue while syncing the text index on the table, and the error is below,

System error: Plsql job execution is failed with error code -20000 and error message ORA-20000: Oracle Text error: DRG-10017: you must be CTXSYS to do this: SYNC

We have granted the USER with CTXAPP and CTXSYS roles.

We are scheduling the SYNC from the QUARTZ Scheduler and it happens for every 5 Minutes. We are getting this error in ADHOC Basis.

Could anyone help us in solving the issue.

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points