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.
to be able to run ctx_ddl.sync_index as a database job it is necessary to have explicit grants for ctx_ddl, the inheritance via the role ctxapp does not suffice.
SQL> grant execute on ctxsys.ctx_ddl to <user_submitting_the_job>;
Are you calling sync_index without providing an index name?
The manual states:
When idx_name is null, all CONTEXT, CTXRULE, and
CTXXPATH indexes that have pending changes are synchronized. You
must be connected as ctxsys to perform this operation ...