4 Replies Latest reply: Jun 8, 2012 8:14 AM by user13780543 RSS

    ERROR while syncing the Text Index

    user13780543
      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.