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

    ERROR while syncing the Text Index

      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.