Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CTX_DDL.SYNC_INDEX versus ALTER INDEX REBUILD ONLINE

Kim POct 27 2014 — edited Oct 28 2014

I have created table indexes (Oracle 11g) for Searching (Oracle Text) that are to be synched manually at night and I am trying to figure out the BEST way to sync.

Should I use CTX_DDL.SYNC_INDEX or ALTER INDEX REBUILD ONLINE.

I would like to maintain my properties (TRANSITIONAL, SYNC MANUAL)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 25 2014
Added on Oct 27 2014
2 comments
327 views