oracleoracle12coracle-text

What is the 12c alternative to alter index rebuild online parameters ('sync')

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?

Solution

  • A quick look a the doc, and I would suggest you do:

    exec ctx_dll.sync_index( 'MY_INDEX' )