Oracle Text (MOSC)

MOSC Banner

What operations set CTXSYS.CTX_USER_INDEX_PARTITION.IXP_STATUS to 'NO_INDEX'?

edited Aug 25, 2016 9:30AM in Oracle Text (MOSC) 9 commentsAnswered

We have a simple LOCAL CONTEXT index on a partitioned table in an 11.2.0.3 EE database.  If I create the index UNUSABLE, all the Text partitions have IXP_STATUS = 'NO_INDEX' and no underlying DR# objects are created.  No problem...I just alter rebuild each index partition.  However, in one of our test databases, I see such a partitioned table with 200 out of 2,500 of the index partitions set to NO_INDEX while all the others are INDEXED.  These 200 partitions were created a year after the original Text index partitions were rebuilt and became USABLE, and there are other USABLE/INDEXED partitions

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