We have an index defined as followed
alter index my_index rebuild online parameters ('sync');
During 12c testing, we are getting this error
DRG-11000: invalid keyword SYNC
It seems Oracle have deprecated the sync option in 12c and are recommending to use CTX_DDL.SYNC_INDEX
Could someone give an example of new syntax applicable to my index?
A quick look a the doc, and I would suggest you do:
exec ctx_dll.sync_index( 'MY_INDEX' )