Oracle Text (MOSC)

MOSC Banner

Has anyone experience rows missing from just creating an OT multistore index?

edited Jun 12, 2014 12:00PM in Oracle Text (MOSC) 1 commentAnswered

Hello,

This is the first time i have tried this forum.  I have this issue where I have created a multistore index on 4 columns,  works everywhere except in production (11.2.0.2.0).   In production the index seems to create fine with no errors(in dr$index or in sysout), but yet not all of the records are synced.

CREATE INDEX bib_multistore_ctx ON bib(ot_idx)

      INDEXTYPE IS CTXSYS.CONTEXT

      PARAMETERS('

          datastore BIB_DATASTORE

          section group CTXSYS.AUTO_SECTION_GROUP

          STOPLIST WSILL_BIB_PATRON

          LEXER BIB_INDEX

          storage BIB_CONCAT_STO

          SYNC (MANUAL)') parallel 16;

alter index bib_multistore_ctx noparallel;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center