How to create text index and sync schedule in one step?
January 18th, 2006 By twocoasttb
When creating a context index in 10g you can define the synchronization job in the same statement:
create index synopsis_idx on documents(synopsis)
indextype is ctxsys.context
parameters ('sync (every "FREQ=MINUTELY INTERVAL=5" memory 20M)');
The user creating the index must have the ‘ctxapp’ role and the ‘create job’ privilege. The values supplied for the ‘every’ parameter must be an Oracle Scheduler Calendaring Syntax expression or a PL/SQL expression that evaluates to a date or timestamp.